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 sql a microsoft product?

493


What are the different ddl commands in sql?

576


How do I create a sql database?

518


What is raid? How does it help storage of databases?

599


What are the different dcl commands in sql?

557






How to select 10 records from a table?

641


What is embedded sql what are its advantages?

502


how to concatenate two character strings? : Sql dba

548


How do I view tables in mysql?

538


How to use boolean type in select statement?

580


Sql technical questions

775


Which table is left in left join?

518


Explain the commit statement.

611


how to check myisam tables for errors? : Sql dba

595


What are the types of variable use in pl sql?

563