Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-08153: deleted global script: string

1 Answers  


TNS-01413: "string" established:string refused:string current:string max:string state:string

1 Answers  


ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string

1 Answers  


ORA-09708: soacon: failed to bind socket to port.

1 Answers  


ORA-01290: cannot remove unlisted logfile string

1 Answers  






ORA-00370: potential deadlock during kcbchange operation

1 Answers  


RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command

1 Answers  


ORA-31688: Worker process string failed during startup.

1 Answers  


ORA-19765: mount id string does not match mount id string in control file

1 Answers  


ORA-15175: cannot create alias for diskgroup metadata file 'string'

1 Answers  


QSM-01035: a row level security policy exists on this table

1 Answers  


ORA-32737: Hang analysis aborted due to failed memory allocation

1 Answers  






Categories