Oracle Bug?

I am one of the slowest people on the planet, I hope, to scream bug but this makes no sense. Can anyone clarify this for me?

Oracle 10gR1 (10.1.0.4)

conn / as sysdba
GRANT execute ON dbms_flashback TO uwclass;

conn uwclass/uwclass

CREATE TABLE test (
reason VARCHAR2(20),
scnno NUMBER)
ROWDEPENDENCIES; CREATE OR REPLACE PROCEDURE atx IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   INSERT INTO test VALUES ('ATX', dbms_flashback.get_system_change_number);    COMMIT;
END;
/

BEGIN

• first insert INSERT INTO test VALUES ('TX1', dbms_flashback.get_system_change_number);
• call autonomous transaction atx;
• second insert INSERT INTO test VALUES ('TX2', dbms_flashback.get_system_change_number); ROLLBACK; END; /

SELECT * FROM test;

• No question the autonomous transaction
• is behaving as an autonomous transaction
• should. So explain this?

BEGIN

• first insert INSERT INTO test VALUES ('TX1', dbms_flashback.get_system_change_number);
• call autonomous transaction atx;
• second insert INSERT INTO test VALUES ('TX2', dbms_flashback.get_system_change_number); COMMIT; -- rollback repaced with a commit END; /

SELECT * FROM test;

REASON                    SCNNO
-------------------- ----------
TX1                    17381335
ATX                    17381335
TX2                    17381336

Why is the record committed the PRAGMA AUTONOMOUX_TRANSACTION getting the same SCN as TX1 and why is TX1 not getting the same SCN as TX2? It just seems wrong.

Thanks for any comments.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)