I have a procedure in a procedure. The inner procedure
contains out parameter. How I can call the inner procedure
in the out procedure and send the inner procedure parameter
value(out parameter value) into out procedure?

Answers were Sorted based on User's Feedback



I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the ..

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).

Is This Answer Correct ?    2 Yes 0 No

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the ..

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

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is indexing oracle sql?

0 Answers  


how to saw triggers output in pl/sql database?

1 Answers  


What is query optimization in sql?

0 Answers  


Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  


how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  






What is cost in sql execution plan?

0 Answers  


what is schema? : Sql dba

0 Answers  


i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,


what is dbms? : Sql dba

0 Answers  


What is sqlerrm?

0 Answers  


What are the query optimization techniques?

0 Answers  


overloading of stored procedure is possible in oracle?

3 Answers   Nelco,


Categories