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 programs use sql?
How long it takes to learn pl sql?
what are ddl statements in mysql? : Sql dba
How much does sql cost?
Why are aggregate functions called so?
What are triggers in sql?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the difference between inner join and natural join?
how to do backup entire database? : Transact sql
How long does it take to learn pl sql?
What is the difference between syntax error and runtime error?
What is set serveroutput on?
Explain alias in sql?
What is the use of count (*) in sql?
How to process query result in pl/sql?