Hi guys, am confused about using OUT parameter in pl/sql..as seen on this oracle docs page :-
http://http://docs.oracle.com/cd/B19...s_packages.htm
It says while using OUT parameter, Formal parameter cannot be used in an expression..we know that IN parameter cannot be used as assignment target, but can be used to assign a value, here what is mentioned about OUT parameter is that it cannot be used to assign a value, but please see this code , here y variable is assigned a value using x formal parameter....
Code:
CREATE OR REPLACE procedure proccer1 (n in varchar2, p in number, x out number)
as
Y NUMBER;
cursor firstcur is
select * from temp;
cur_val firstcur%rowtype;
cur_val_point cur_val.point%type;
begin
insert into temp values (n, p);
open firstcur;
loop
fetch firstcur into cur_val;
exit when firstcur%NOTFOUND;
insert into t values (cur_val.point);
end loop;
X := N + 10;
dbms_output.put_line ('the output value : ' || x);
Y := x + 10;
dbms_output.put_line ('now new output value : ' || Y);
close firstcur;
end;
so what is it which is mentioned on that oracle docs page whose link i have given above..?
thanks for the help...