How can I pass the inner procedure value to outer
procedure ?
Answer Posted / s.syam sundar
first declare a variable globaly
and next create inner procedure with in(if need or u can
set defult parameters) and out parameters
and next result of inner procedure is assigned to global
variable
and next in outer procedure u can get the result from global
variable
regads
S.syam sundar
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you optimize a stored procedure in sql?
Explain foreign key in sql?
What is the use of prepared statement?
Which is faster union or join?
what is sql profiler? : Sql dba
What is attribute indicator in pl sql?
What trigger means?
How do you delete a table?
What is over () in sql?
What are different clauses used in sql?
How many sql core licenses do I need?
How do I audit the sql sent to the server?
what is the difference between sql and t-sql? : Transact sql
What is dml and ddl?
how to create a new view in mysql? : Sql dba