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 Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What is scalar function in sql?

0 Answers  

---

Do we need to create index on primary key?

0 Answers  

---

What is the difference between a procedure and a function?

0 Answers  

---

What is serial sql?

0 Answers  

---

Can we perform dml on view?

0 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

Is big data nosql?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

What are hotfixes and patches?

0 Answers  

---

How delete all records from table in sql?

0 Answers  

---

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

0 Answers  

---