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?
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
Why we use join in sql?
Is microsoft sql free?
Is vs as in pl sql?
What is delete command in sql?
What is sql clause?
what is sql in mysql? : Sql dba
how to concatenate two character strings? : Sql dba
What is a temporal data type?
What is clustered and nonclustered index in sql?
what is try_catch block in procedure
what are the limitations of identity column? : Transact sql
Do ddl statements need commit?
What is a natural join sql?
What is the use of nvl function?
How do you write a subquery?