Answer / 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.

Answer / 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

What are hotfixes and patches?

0 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---

What is the use of stored procedures?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

What is crud stand for?

0 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Can you load data into multiple tables at once? : aql loader

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is primary key in db?

0 Answers  

---