Oracle DBA, How To, Error, Cause and Action

ORA-01725: USERENV('COMMITSCN') not allowed here

ORA-01725: USERENV('COMMITSCN') not allowed here




Cause: The function USERENV('COMMITSCN') is only allowed as a top-level expression in the VALUES clause of an INSERT statement, and on the right-hand side of an assignment in an UPDATE statement.




Action: Correct the use of the function.