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...

How can I pass the inner procedure value to outer
procedure ?

Answer Posted / som

1. Declare a variable as the datatype of the out parameter
of the inner procedure.
2. Call the inner procedure with the input/output
parameters- input parameter values and output parametr as
the variable declared.
3. After the inner procedure gets executed, the output
parameter will be accessible to the outer procedure.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What programs use sql?

978


How long it takes to learn pl sql?

992


what are ddl statements in mysql? : Sql dba

1171


How much does sql cost?

971


Why are aggregate functions called so?

931


What are triggers in sql?

1004


How can one get sql*loader to commit only at the end of the load file? : aql loader

1039


What is the difference between inner join and natural join?

988


how to do backup entire database? : Transact sql

1108


How long does it take to learn pl sql?

1044


What is the difference between syntax error and runtime error?

1119


What is set serveroutput on?

1119


Explain alias in sql?

1026


What is the use of count (*) in sql?

1027


How to process query result in pl/sql?

1102