Answer Posted / bhavani sharan singh

Hi,

If i am correctly understand your question then solution is
given below,

Suppose the Inner procedure is

Prc_inner(pov_out_param OUT varchar2 )

and Outer Procedure is

Prc_outer( pov_out_paaram2 OUT varchar2)
as
lv_out_param VARCHAR2(SIZE)
begin
Prc_inner(lv_out_param );
--Assiging the inner value to outer procedure paramaeter
pov_out_param := lv_out_param ;

EXCEPTIOn
when others then
NULL;

END

Is sql open source?

974

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

---

What is keys and its types?

1075

---

What are properties of the transaction?

998

---

How do I add a primary key to a table?

1042

---

Where the sql database files are stored?

1014

---

Is it important to partition hard disk?

1024

---

What kind of join is join?

970

---

how to include numeric values in sql statements? : Sql dba

1099

---

what is the syntax used for partition in tsql? : Transact sql

1014

---

Explain lock escalation? : Transact sql

1197

---

how many values can the set function of mysql take? : Sql dba

987

---

Which is better cte or subquery?

1028

---

when MSQL8.0 is in market

2076

---

What is difference between cursor and trigger?

1074

---