Calling of Oracle PL/SQL Package using Orchestrator

ArndtHumpert93678 — Fri, 18 Dec 2020 10:07:51 GMT

Dear Contributors,

we like to call oracle stored procedure using orchestrator.

How to call a stored procedure with out parameter.

procedure sample_proc_with_outval ( p_result out varchar ) is

begin

return "test value";

end;

Question is how to use the p_result variable in further processing.

How to call a stored function which is having an return value

function sample_function

return number

l_num number(20);

begin

l_num:=999;

return l_num;

end;

Question here is how to get the result of the stored procedure.

Thank you 🙂

topic Calling of Oracle PL/SQL Package using Orchestrator in Controllers