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
How do I sort a table in sql?
Can I create table without primary key?
Which join is default?
Can a primary key be a foreign key?
What is the difference between join and natural join?
What is the difference between a subquery and a join?
What is parameter substitution in sql?
What does fetching a cursor do?
What is the starting oracle error number? What is meant by forward declaration in functions?
How does postgresql compare to "nosql"?
what is view? : Sql dba
what is not null constraint? : Sql dba
What are the operators used in select statements?
How do temporal tables work?
How can use stored procedures in sql?