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


Please Help Members By Posting Answers For Below Questions

What is normalisation in sql?

766


How to write a query to show the details of a student from students table whose

753


what are the advantages and disadvantages of views in a database? : Sql dba

758


What is benefit of creating memory optimized table?

696


Is inner join same as self join?

781






explain advantages of innodb over myisam. : Sql dba

827


what is bdb (berkeleydb)? : Sql dba

751


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

762


How many types of sql are there?

719


How do I view a view in sql?

695


Is oracle sql free?

726


Does a join table need a primary key?

706


What are the two types of exceptions in pl/sql?

729


Why plvtab is considered as the easiest way to access the pl/sql table?

826


Why is sql*loader direct path so fast?

793