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

Answers were Sorted based on User's Feedback



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

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

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

Answer / s.syam sundar

first declare a variable globaly
and next create inner procedure with in(if need or u can
set defult parameters) and out parameters
and next result of inner procedure is assigned to global
variable
and next in outer procedure u can get the result from global
variable

regads
S.syam sundar

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is bdb (berkeleydb)? : Sql dba

0 Answers  


What is full join?

0 Answers  


What is set serveroutput on in pl sql?

0 Answers  


What does seeding a database mean?

0 Answers  


what is the use of double ampersand (&&) in sql queries?

0 Answers  






How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,


Advantages and disadvantages of stored procedure?

0 Answers  


What is sql and also describe types of sql statements?

0 Answers  


How to make a copy values from one column to another in sql?

0 Answers  


what is the command line end user interface - mysql? : Sql dba

0 Answers  


What is dbo in sql?

0 Answers  


What is field delimiter?

0 Answers  


Categories