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 is difference between nchar and nvarchar?

0 Answers  

---

Is sqlite free?

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---

What is data control language?

0 Answers  

---

Is sql pronounced sequel or sql?

0 Answers  

---

---

What is the max nvarchar size?

0 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

What is a sql trace file?

0 Answers  

---

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

How to convert ms-excel file to oracle table?

2 Answers  

---