how to get out parameters from oracle procedure in logic app?

Question

Hi ,

I am trying to execute oracle procedure with parameters.

if i don't add out parameters in oracle procedure, logic app runs successfully. however, i got error when I add out parameter in the procedure. is there a way i can get the out parameter from oracle to logic app?

"status": 400, "message": "Oracle: ORA-06550: line 2, column 322:\nPLS-00363: expression ' NULL' cannot be used as an assignment target\nORA-06550: line 2, column 328:\nPLS-00363: expression ' NULL' cannot be used as an assignment target\nORA-06550: line 2, column 2:\nPL/SQL: Statement ignored\r\n inner exception: Oracle: ORA-06550: line 2, column 322:\nPLS-00363: expression ' NULL' cannot be used as an assignment target\nORA-06550: line 2, column 328:\nPLS-00363: expression ' NULL' cannot be used as an assignment target\nORA-06550: line 2, column 2:\nPL/SQL: Statement ignored\r\nclientRequestId: da83a719-340e-47f3-bc6d-7bbade19dac1",

Answer 1

Hi @Jo Chun , It's a known limitation with logic app connector. Though there are 2 ways of doing this - Execute the SP and as a part of that execution insert the data in temp table and retrieve it then using next action from that table which will just serve the purpose of holding this result. Other option is to create an azure function and execute your sp from azure function and retrieve the output, you can call this azure function from logic app.

Answer 2

@Jo Chun ,

Welcome to the Microsoft Q&A Platform, and thank you for reaching out!

Currently, Logic Apps does not support retrieving OUT parameters directly from Oracle stored procedures. We understand how important this feature can be, and we appreciate your feedback.

For more details, you can refer to the documentation on known issues and limitations for Oracle Connectors: Known Issues and Limitations - Oracle Connectors

If this addresses your query, kindly mark this answer as "Accepted" and click "Yes" under "Was this answer helpful?" If you have any further questions or need additional assistance, please feel free to let us know—we’re here to help!