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 a merge query?

1 Answers  

---

How is a process of pl/sql compiled?

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---

What are the different types of triggers?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

What is the use of function in sql?

0 Answers  

---

What is an exception in pl/sql?

0 Answers  

---

What is an escape character in sql?

0 Answers  

---