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

Explain the types of joins in sql?

0 Answers  

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What are reports usually used for?

0 Answers  

---

How to assign sql query results to pl sql variables?

0 Answers  

---

How do I use google cloud in sql?

0 Answers  

---

What is integrity in sql?

0 Answers  

---

Can we rollback after truncate?

0 Answers  

---

How do I save a sql query?

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

What are different clauses used in sql?

0 Answers  

---