How to pass parameter to oracle stored procedure using Logic apps

Question

Hi Team,

I am using Logic apps to call oracle Stored procedure.

I am using Action : "Execute Oracle Query" and using BEGIN END Block i am calling the package . procedure.

however, it doesn't work in case if i pass the in or out parameters.

can you please help to know the how to pass IN and Out parameters

BEGIN

xx.yy(Param1 );

END;

Answer 1

Mahendra Pawar Thanks for posting your question in Microsoft Q&A. As discussed in other thread, there are known issues and limitations with Oracle Connectors, and currently, OUT parameters are not supported. In such scenarios, the recommendation is to use other services such as Azure Functions which can trigger Stored Procedure as you needed. I see a similar feedback Support Output Parameters within Oracle Connector in our feedback forum and suggest you upvote this idea. This will help our product team prioritize the features.

However, you can use SQL query to call the stored procedure with input parameters and let me know the details about the error or elaborate on the issue you are facing.

I hope this helps and let me know if any questions.

---

If you found the answer to your question helpful, please take a moment to mark it as "Yes" for others to benefit from your experience. Or simply add a comment tagging me and would be happy to answer your questions.