can we call a procedure into another procedure?If yes means
how you can pass the perameters for the two procedures?
- 2 Answers
- 12616 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
Can I call a procedure inside a function?
How do you exit in sql?
Is time a data type in sql?
What is difference between mysql and postgresql?
What is the difference between a procedure and a function?
How do I run a pl sql procedure in sql developer?
Which is faster count (*) or count 1?
What is the difference between joins?
Is it important to partition hard disk?
What is latest version of sql?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Which command is used to delete a package?
What are secondary keys?
What kind of join is join?
What is an alias command?
