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 is table? : Sql dba

1109


How do I truncate a word?

1163


Explain what is an index?

1106


How many databases can sql express handle?

1032


how to drop an existing table in mysql? : Sql dba

1093


what are the limitations of identity column? : Transact sql

1163


Which is faster joins or subqueries?

1037


What is fmtonly in sql?

1165


how to include character strings in sql statements? : Sql dba

1141


What is scalar and vector?

1063


what are myisam tables? : Sql dba

1079


What is pls_integer in pl sql?

1158


What is trigger types of trigger?

1144


Can one improve the performance of sql*loader? : aql loader

1099


How to display the current date in sql?

1129