Hi, If i am correctly understand your question then solution is given

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?

Question Posted / bhavani sharan singh

2 Answers
7998 Views
I also Faced
E-Mail Answers

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is duration in sql profiler trace?

1086

What is difference between cursor and trigger?

1084

what are date and time intervals? : Sql dba

1063

What is #table in sql?

1109

What is a temporal table?

935

Why join is faster than subquery?

1118

What are the sql aggregate functions?

1138

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

966

how to check myisam tables for errors? : Sql dba

1324

What is cte sql?

1003

What is int identity in sql?

1151

What is sql catalog?

1028

How do you take the union of two tables in sql?

990

how to fetch common records from two tables? : Sql dba

1183

what is the use of double ampersand (&&) in sql queries?

1178