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
is
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
