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

Does truncate table reset auto increment?

0 Answers  

---

Explain the concept of normalization.

3 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---

Why truncate is faster than delete?

0 Answers  

---

How to execute a stored procedure?

0 Answers  

---

Can dml statements be used in pl/sql?

0 Answers  

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is database sql?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

What is a trigger word?

0 Answers  

---

can i create trigger on synonym is it possible or not please help me

4 Answers   CGI,

---