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 many disk partitions should I have?
What is scalar and vector?
what is a join? : Sql dba
Advantages and disadvantages of stored procedure?
What are views in sql?
What is a left join?
How do sql databases work?
Does inner join remove duplicates?
how to enter binary numbers in sql statements? : Sql dba
What is a record in a database?
What is pivot in sql?
How do you write a subquery?
What is difference between rank () row_number () and dense_rank () in sql?
What is the difference between clustered and non-clustered index in sql?
what is the different between now() and current_date()? : Sql dba