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

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
13245 Views
Fujitsu, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is record data type?

916

What are local and global variables and their differences?

1090

What is native sql query?

1019

How many sql databases can you have on one server?

1082

What is difference between procedure and trigger?

980

What are sql ddl commands?

1090

What are the different type of joins in sql?

956

Explain what is an index?

1056

What is sequence in sql?

1016

How do I view tables in mysql?

985

Why do we use procedures in pl sql?

1039

What is the use of function "module procedure" in pl/sql?

1197

Is join and inner join the same?

1002

What is indexing oracle sql?

1105

what are wild cards used in database for pattern matching ? : Sql dba

1143