to call a procedure inside another procedure in oracle
How to call a procedure in a different procedure
create package XX
procedure xx1( a in number,b in number , c out number, ret_msg out varchar2, ret_status varchar2)
procedure xx2 ( x in number, y in number)
end XX;
create package body XX is
procedure xx2 ( x in number, y in number)
cursor c1 is select a1,b1 from xx_table
for i in 1..5
-- The a1 and b1 should be passed as input parameters to procdure xx1.
end XX;
Thanks in advance