LIQY@XE> declare
2 begin
3 insert into t1 values (100);
4 dbms_output.put_line(SQL%ROWCOUNT);
5 COMMIT;
6 dbms_output.put_line(SQL%ROWCOUNT);
7 end;
8 /
1
0
PL/SQL procedure successfully completed.
In 8i the output is the same , however behavior in 10g & 11g is as above.
I think it is related to COMMIT.
This comment has been removed by the author.
ReplyDelete