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
What does the hierarchical profiler does?
what is the difference between blob and text? : Sql dba
How much does sqlite cost?
How does sql profiler work?
How is pl sql different from sql?
How many clustered indexes can you have?
Do we need to rebuild index after truncate?
how are mysql timestamps seen to a user? : Sql dba
What is anonymous block in sql?
What is numeric function sql?
what are wild cards used in database for pattern matching ? : Sql dba
what are the advantages and disadvantages of views in a database? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
What is the usage of sql functions?
What is orm in sql?