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

Vijay Prasath P 25 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.

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

Your answer

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