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

Write an sql query to select all records from the table?

0 Answers  

---

How do you use collections in procedure to return the resultset?

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

What jobs use sql?

0 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

How to find 3rd highest salary of an employee from the employee table in sql?

0 Answers  

---

What are sql indexes?

0 Answers  

---

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

---

Does sql backup shrink transaction log?

0 Answers  

---

Why we use pl sql?

0 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---