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
What is the order of sql select?
What is pl/sql table? Why is it used?
What are schema-level triggers?
What is difference between function and trigger?
Why do we create views in sql?
What is an inner join sql?
What is cross join example?
What is the difference between a database and a relational database?
Determine if oracle date is on a weekend?
Is not equal in sql?
What is group by in sql?
What is snowflake sql?
What are the parts of a sql statement?
How to select random rows from a table?
What is difference between procedure and trigger?