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

How many sql databases can you have on one server?

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is user define exception and example

1 Answers   HP, KP,

---

What are triggers and its types?

0 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

How do I view a procedure in sql?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

What are the dml statements?

0 Answers  

---