18.04.2024
15:27
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
