Calling Oracle DB Stored Procedures with Parameters in iPaaS

Hi,

I am trying to call a stored procedure in iPaaS using a connector for Oracle DB. I can successfully execute a procedure without parameters, but I encounter issues when attempting to call a procedure with parameters. Could anyone provide me with a correct example or format for calling a procedure with parameters?

Thanks,

Waheed

 

Tags iPaaS
Asked by Waheed Barakzai on Wed 7/10/24 10:06 AM
Sign In to leave feedback or contribute an answer

Answers (2)

This answer has been marked as the accepted answer
Jordyn Mancini Tue 7/16/24 12:05 PM

Hi Waheed - 

The error that shows on the SQL step in the flow makes me think there's a syntax issue with the stored procedure itself. It would be helpful to see that stored procedure if possible - but I don't recommend sharing that on this Questions forum. 

Can you instead create a Support Ticket for this so we can help you out there? If you are able to share the SQL code for that stored procedure to that ticket, that would be great. 

Here is the link to create a Ticket: https://solutions.teamdynamix.com/TDClient/1965/Portal/Requests/TicketRequests/NewForm?ID=xpZEc1adGco_&RequestorType=ServiceOffering

 

Thank you,

Jordyn Mancini 

No feedback
Mark Sayers Wed 7/10/24 10:16 AM

Hello Waheed,

Can you provide the name of the flow you are trying to work from?

Sincerely,
Mark Sayers
Sr Support Consultant, CS

No feedback
Hi Mark,
Here is the flow name: test procedure - Waheed Barakzai Wed 7/10/24 10:18 AM