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 the need of a partition key?

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

How do you go back in sql?

0 Answers  

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---

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

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---

What is t sql used for?

0 Answers  

---

How do I create a sql script?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

What do you understand by case manipulation functions?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---