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

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1095

---

Which are the different character-manipulation functions in sql?

1112

---

What is the purpose of the partition table?

1089

---

What are different joins used in sql?

1107

---

How to read/write files from pl/sql?

1085

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1140

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1092

---

What does trigger mean in psychology?

1008

---

Does sql between include endpoints?

1060

---

How to change the order of columns in Oracle SQL Plus ?

1102

---

Explain how to use transactions efficiently : transact sql

1017

---

How can check sql version from command line?

1138

---

What is sql server and ase?

1069

---

Can we connect to postgresql using sql developer?

1048

---

What is mdb stand for?

1059

---