Oracle DBA, How To, Error, Cause and Action

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction

ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction


Cause:


The USERENV('COMMITSCN') function can only be used once in a transaction.



Action:


Re-write the transactioin to use USERENV('COMMITSCN') only once

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)