I posted
this question on AskTom at and Tom suggested I open an iTar. However, I'm on XE, so that route is not open to me. So, for what it's worth, I'm making a request here in the hope that Oracle will do something about it, even though it's not an XE-specific issue.
Specifically, the article by Natalka Roshak at
http://www.orafaq.com/node/76
says:
"It seems that DML errors are logged as an autonomous transaction; rolling back
the DML that spawned the error does not clear the error logging table."
Can you please document this? An ideal place would be in INSERT, UPDATE, and MERGE topics in the SQL Reference.
I did find a
passage in the Administrator's Guide that reads:
"If the statement exceeds the reject limit and rolls back, the error logging table retains the log entries recorded so far."
However, nowhere (that I can find) does it specify what happens if the statement does not exceed the reject limit and you subsequently roll back the transaction
explicity.
Thanks.