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
- 8090 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 are the types of optimization?
Will truncate release space?
What is the usage of when clause in trigger?
What is the use of pl/sql table?
Why do we need sharding?
Explain the working of foreign key?
Explain what is table in a database?
What is sequence in sql?
how to rename an existing table in mysql? : Sql dba
What are the datatypes available in pl/sql ?
what is the syntax for using sql_variant_property? : Transact sql
What is input buffer in sql*plus?
What are basic techniques of indexing?
Does mysql_real_escape_string prevent sql injection?
What is embedded sql in db2?
