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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is record in oracle pl sql?

696


what are the differences between char and varchar? : Sql dba

748


how to get @@error and @@rowcount at the same time? : Sql dba

741


What jobs use sql?

721


What can you do with pl sql?

770






How do I pipe the output of one isql to another?

722


What are inner outer left and right joins in sql?

733


Why is a trigger used?

697


What is difference between my sql and sql?

723


What is cursor in pl sql with examples?

674


What is user in sql?

762


What are the different types of a subquery?

715


How to display Row Number with Records in Oracle SQL Plus?

771


Explain select statements in sql?

759


What is synonyms?

773