Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

what are the advantages of mysql in comparison to oracle? : Sql dba

1008


How do you rename a table in sql?

1121


How many types of sql are there?

992


What does trigger mean in psychology?

968


Why truncate is faster than delete?

1119


What is sql catalog?

1028


how to increment dates by 1 in mysql? : Sql dba

984


Differentiate between pl/sql and sql?

1156


How do you create a db file?

1020


Can delete statement be rollbacked?

991


How to run pl/sql statements in sql*plus?

1085


What information is needed to connect sql*plus an oracle server?

1033


What is trigger types in sql?

1000


Can we perform dml in function?

1073


Is pl sql a programming language?

998