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
(Move to ...)
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
‹
›
Home
View web version