Accessing oracle out parameter (Parameter Type - SYS_REFCURSOR) in azure logic app standard

Vijay Prasath P 20 Reputation points
2024-07-17T13:32:36.8733333+00:00

I have a procedure which has out 3 parameters

P_XML_OUT SYS_REFCURSOR;  
P_ERROR_CODE_OUT VARCHAR2(32767);  
P_ERROR_DESCR_OUT VARCHAR2(32767);

P_XML_OUT this parameter is returning XML data, I tried to execute the procedure using oracle execute query action with below queries (refer below images)
image

User's image

none of the above works, looking for an right way to get XML data as my output from out param using logic app standard.

Thanks in advance.

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
365 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,201 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.