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

TNS-01081: Started with pid=string

1 Answers  


LSX-00154: attribute "use" must have its value set to "optional"

1 Answers  


ORA-02214: duplicate BACKUP option specification

1 Answers  


NZE-29005: The certificate is invalid.

1 Answers  


EXP-00060: an object type had multiple TYPE BODYs

1 Answers  






ORA-24141: rule set string.string does not exist

1 Answers  


ORA-19852: error creating services for auxiliary instance string (error string)

1 Answers  


NNC-00424: invalid address "string"

1 Answers  


QSM-02037: cannot evaluate constant expression at compile time

1 Answers  


ORA-13774: insufficient privileges to select data from the workload repository

1 Answers  


TNS-00551: underlying transport connection failed

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


Categories