Home > Forum > General > Retrieve output parameter value from Oracle procedure

Retrieve output parameter value from Oracle procedure
0

Hello,

We have set a working Oracle connection. There is a procedure with 2 params, one IN, another OUT. Running a Business Rule containing a SQL Command against the Oracle connection:

declare
l_out NUMBER;
begin
ZZ_WEBCON_TEST.TEST_PROCEDURE(P_IN => {BRP:21}, X_OUT => l_out);
end;

where {BRP:21} is a Business Rule decimal parameter.
The Rule is working, Oracle procedure gets executed (witness on Oracle db) and most probably returns l_out.

My question is: how do I get the l_out value? Tried another Rule parameter but query not working any longer.

Thank you,
Mihail

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.