Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 the difference between having and a where in sql?

0 Answers  


What are the different sql languages?

0 Answers  


What are the disadvantages of not performing database normalization?

0 Answers  


What is dynamic sql in pl sql?

0 Answers  


Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.

1 Answers   CTS,






What are the types of variable use in pl sql?

0 Answers  


Can We write bulk collect statement in triggers?

1 Answers   Polaris,


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  


How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,


What is the result, when NULL is compared with NULL?

21 Answers   TCS,


suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  


What is indexes?

0 Answers  






Categories