Oracle Database 12c New Features

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.