Unanswered

Need KB article on how to invoke Oracle stored procedure from within Power Platform

(1) Share

Report

Posted on by PT-13021458-0

I have tried leveraging the Oracle database connector action "Execute stored procedure" in Power Automate but it does not work, any suggestions?

When I use this action, I can only select stored procedures from the "Procedures" folder in my database. However, I am trying to execute stored procedures located in the "Packages" folder in my database. How can I enable this?

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (1)

Report
Hi,

First let's start with these:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-oracledb

https://learn.microsoft.com/en-us/connectors/oracle/

Second,

My car won't start. Think about that statement. You have no idea how to help the person over the phone let alone, someone over the internet who just says it doesn't work, help me.

Please share your actions, your inputs, the details of a run where it "didn't work" and explain what didn't work means.

To me, what you are doing, I believe may be considered nested and nested are not support, but its a guess based on the limited information you provided about the actual issue and details about "didn't work"

Cheers

Was this reply helpful? Yes No
PT-13021458-0 2 on at

Like (0)

Report

Thanks FLMike,

I have attached a PowerPoint containing screenshots of the stored procedure I am trying to call as well as my attempts to use both Oracle connector actions. When I try to call a Package stored procedure using the "Execute an Oracle query" action in Power Automate, the process seems to never finish running and I get a status of "BadGateWay".

Alternatively, when I use the "Execute stored procedure" action, I am unable to see stored procedures from the Packages folder in my database. I only get a list of stored procedures found in the Procedures folder. Hence, I am unable to use this action to call Package procedures.

I am connected to a colo-hosted Oracle database.

Please let me know if you need any further details.

stored_proc_call_...

Was this reply helpful? Yes No