Tips for Oracle DBA
Oracle Database Administration, How To, Daily DBA jobs, Oracle Error Cause and Action
Oracle DBA, How To, Error, Cause and Action
Back To Menu
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
Newer Post
Older Post
Home
