Answer / naren

i think by this code u may understand



create or replace procedure p1(a out number) as
begin
a:=10;
end;
/


create or replace procedure p2 as
b number;
begin
p1(b);
dbms_output.put_line('value of inner pro paramter is:'||b);
end;
/


this code work successfully and pass a(out param of p1)
into b(variable of p2).

Answer / 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

what is uncommittable transactions? : Transact sql

0 Answers  

---

What is sql keyword?

0 Answers  

---

What is difference between function and trigger?

0 Answers  

---

Why do we use function in pl sql?

0 Answers  

---

What are different types of keys?

0 Answers  

---

Is it possible to update views?

0 Answers  

---

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

---

What is procedure and function in sql?

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

How does sql developer connect to oracle database?

0 Answers  

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---