Hello experts,
DB Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
I have the following code:
set serveroutput on;
declare
n number := 100;
procedure p(n1 in number, n2 in out number, n3 in out nocopy number)
is
begin
n2 := 200;
dbms_output.put_line('1: '||n1);
n3 := 300;
dbms_output.put_line('2: '||n1);
end;
begin
p(n,n,n);
dbms_output.put_line('3: '||n);
end;
/
And the output:
1: 100
2: 300
3: 200
What I don't understand is the last line of the output.
Why would it be 200 but not 300 ?
Regards,
Ranagal