How can I pass the inner procedure value to outer
procedure ?
Answers were Sorted based on User's Feedback
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 |
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 |
What is the purpose of normalization?
How do I add a primary key to a table?
What are the advantages of VIEW?
What is differance unique key and primary key.
What is normalization in a database?
What are the differences between Database Trigger and Integrity constraints ?
What version is sql?
Does group by remove duplicates?
What is synchronized subquery?
What is the maximum number of columns in sql table?
Types of cursors and explanation each of them ?
Explain cursor types?