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

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,


What will you get by the cursor attribute sql%rowcount?

0 Answers  


Is truncate ddl or dml?

0 Answers  


discuss about myisam key cache. : Sql dba

0 Answers  


What is the difference between alter trigger and drop trigger statements?

0 Answers  






What is cross join sql?

0 Answers  


How does sql developer connect to oracle database?

0 Answers  


What is bitemporal narrowing?

0 Answers  


how do you login to mysql using unix shell? : Sql dba

0 Answers  


how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  


What do you mean by “trigger” in sql?

0 Answers  


What is the maximum size of sqlite database?

0 Answers  


Categories