PL/SQL (MOSC)

MOSC Banner

to call a procedure inside another procedure in oracle

edited Dec 16, 2015 8:40AM in PL/SQL (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center