When I try to call an Oracle package stored procedure using the "Execute an Oracle query" action in Power Automate, I do not get an output value. However when I run it in Oracle SQL Developer it is working.
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 further details are required.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
