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
- 7976 Views
- I also Faced
- E-Mail Answers
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 the limitation on the block size of pl/sql?
What is the process of copying data from table a to table b?
What is the example of procedure?
Can I join the same table twice?
What is cursor in pl sql?
How do you exit in sql?
What is the need of a partition key?
What is attribute indicator in pl sql?
What is the difference between joins?
How does postgresql compare to mysql?
Write a query to find the names of users that begin with "um" in sql?
What is package in pl sql with an examples?
How do you sort in sql?
What does the hierarchical profiler does?
What is the use of triggers?
