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 / 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 |
Post New Answer View All Answers
what is sql profiler? : Sql dba
How do I tune a sql query?
What is cursor and its types?
Is pl sql a programming language?
Can function return multiple values in sql?
what are enums used for in mysql? : Sql dba
What is cursor in pl sql with examples?
Can %notfound return null after a fetch?
What are different functions in sql?
What are string functions in sql?
What is latest version of sql?
Why is the cursor important?
What is date functions?
How much does sql certification cost?
how to include numeric values in sql statements? : Sql dba