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



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

Answer / guest

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

Action: Correct the use of the function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31668: Timeout before worker process string finished initialization.

1 Answers  


ORA-32332: cannot refresh materialized view "string"."string" as type evolution has occured

1 Answers  


ORA-23345: table "string"."string" not registered to collect statistics

1 Answers  


ORA-39102: Timeout before master process string finished initialization. Master error:

1 Answers  


ORA-13209: internal error while reading SDO_INDEX_METADATA table

1 Answers  






ORA-30362: dimension column cannot be a sequence

1 Answers  


ORA-01539: tablespace 'string' is not online

1 Answers  


ORA-32823: subscriber exists for queue string and destination string

1 Answers  


DRG-50305: getcmd() called when one of the queue names is NULL

1 Answers  


LSX-00258: invalid escape character

1 Answers  


RMAN-05506: error during recursive execution

1 Answers  


ORA-28560: error in configuration of agent process

1 Answers  


Categories