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

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings