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
begin
a:=10;
end;
/
create or replace procedure p2 as
b number;
begin
p1(b);
dbms_output.put_line('value of inner pro paramter is:'||b);
end;
/
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
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 |
Can we use ddl statements in stored procedure sql server?
How many types of triggers exist in pl/sql?
Can we insert in view in sql?
how to concatenate two character strings? : Sql dba
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
Does sql full backup truncate logs?
How does a self join work?
explain about mysql and its features. : Sql dba
What is bulk collections?
In pl/sql, what is bulk binding, and when/how would it help performance?
Can we use pl sql in mysql?
Why cross join is used?