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 pl sql script?

0 Answers  


what is bulk bind

4 Answers   TCS,


How do you clear the screen in sql?

0 Answers  


Does sql support programming?

0 Answers  


What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,






How do you know if a relationship is 2nf?

0 Answers  


how to create object in plsql

3 Answers   Microsoft,


Why do we create views in sql?

0 Answers  


What are the set operators in sql?

0 Answers  


Does a join table need a primary key?

0 Answers  


What is a sql trace file?

0 Answers  


What is the difference between an inner and outer join?

0 Answers  


Categories