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
Answer / naren
i think by this code u may understand
create or replace procedure p1(a out number) as
create or replace procedure p2 as
dbms_output.put_line('value of inner pro paramter is:'||b);
this code work successfully and pass a(out param of p1)
into b(variable of p2).
|Is This Answer Correct ?||2 Yes||0 No|
Answer / bhavani sharan singh
If i am correctly understand your question then solution is
Suppose the Inner procedure is
Prc_inner(pov_out_param OUT varchar2 )
and Outer Procedure is
Prc_outer( pov_out_paaram2 OUT varchar2)
--Assiging the inner value to outer procedure paramaeter
pov_out_param := lv_out_param ;
when others then
|Is This Answer Correct ?||1 Yes||0 No|
What is the difference between having and a where in sql?
What are the different sql languages?
What are the disadvantages of not performing database normalization?
What is dynamic sql in pl sql?
Easy way to convert tableau "IF - ELSEIF" statements to Netezza "CASE" statements.
What are the types of variable use in pl sql?
Can We write bulk collect statement in triggers?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How to perform a loop through all tables in pl/sql?
What is the result, when NULL is compared with NULL?
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
What is indexes?