Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7977 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
What is the usage of sql functions?
What is clustered index sql?
How do you create a db file?
Explain the select statement in sql?
What is the difference between a database and a relational database?
How do I run sql profiler?
What do you mean by query optimization?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is the use of sqlerrd 3?
Can dml statements be used in pl/sql?
What is difference between sql and excel?
What trigger means?
How do I clear the screen in sql plus?
How does an execution block start and end in pl sql?
How do I add a primary key to a table?
