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
Differentiate between syntax and runtime errors.
Why use triggers in sql?
What is the maximum size of sqlite database?
how mysql optimizes distinct? : Sql dba
Is grant a ddl statement?
How many columns should be in an index?
What is the difference between microsoft sql and mysql?
what is the difference between char and varchar data types? : Sql dba
What is a primary key called that is made up of more than one field?
What is trigger types in sql?
how to calculate expressions with sql statements? : Sql dba
What is composite data type in pl sql?
What is compound trigger?
Can a select statement fire a trigger?
Which is better join or inner query?