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


Please Help Members By Posting Answers For Below Questions

Does sqlite need a server?

541


What are the steps for performance tuning.

847


What is trigger in flip flop?

518


What are the differences between in and exists clause?

571


What is localdb mssqllocaldb?

623






How many triggers can be applied to a table?

600


What does trigger mean in slang?

531


what is schema? : Sql dba

564


What company owns postgresql?

562


How do I count rows in sql?

561


Which normal form is best?

517


What is use of package in pl sql?

534


Does truncate require commit?

546


What is clause in sql?

586


What is aggregate function in sql?

539