can we call a procedure into another procedure?If yes means how you can pass t

can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?

Question Posted / swapna

2 Answers
12127 Views
Fujitsu, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can we call a procedure into another procedure?If yes means how you can pass the perameters for t..

Answer / madhuri

We can call a procedure into another procedure.

create or replace procedure proc1(empno number) is
begin
proc2(20,'CLERK');
end;

When we execute proc1 as follows
exec proc1(7891);

it will execute proc1 and proc2 as well

Is This Answer Correct ?

7 Yes

6 No

can we call a procedure into another procedure?If yes means how you can pass the perameters for t..

Answer / swapna

while creating a procedure body we can call other procedure
in that body

for example if your creating the procedure body p1 we can
call the procedure p2 in the procedure body p1

syntax

create or replace procedure p1(a number) is
b number;
begin
p1(10);-- calling first procedure
end;
when you execute procedure p1
exec p1(10) -- it will execute both p1 and p2

Is This Answer Correct ?

9 Yes

9 No

Post New Answer