How can I pass the inner procedure value to outer
procedure ?
- 2 Answers
- 7027 Views
- I also Faced
- E-Mail Answers
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 to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
how can you create an empty table from an existing table? : Sql dba
Can we write ddl statements in functions?
What do you mean by table in sql?
How to install oracle sql developer?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Why is sql*loader direct path so fast?
Can we debug stored procedure?
What are the types of sql commands?
What is trigger with example?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Differentiate between pl/sql and sql?
which tcp/ip port does sql server run on? : Sql dba
Explain what is an index?
What is blind sql injection?
