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.
Saturday, September 05, 2009
Subscribe to:
Post Comments (Atom)
This comment has been removed by the author.
ReplyDelete