cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
133
Views
0
Helpful
0
Replies
Highlighted

Calling of Oracle PL/SQL Package using Orchestrator

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

 

0 REPLIES 0
Content for Community-Ad

This widget could not be displayed.