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-01546: tablespace contains active rollback segment 'string'

1 Answers  


SQL*Loader-00109: Invalid number of logical records to skip

1 Answers  


NNL-00512: Shows or sets the server's auto-refresh expiration period

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


PCC-01007: WORKING-STORAGE SECTION not found

1 Answers  






QSM-02061: one or more joins present in mv

1 Answers  


RMAN-08591: WARNING: invalid archivelog deletion policy

1 Answers  


RMAN-06159: error while looking up backup set

1 Answers  


PLS-00708: Pragma string must be declared in a package specification

1 Answers  


ORA-30120: 'string' is not a legal oracle number for 'string'

1 Answers  


NNL-01043: Data stream answer failures: number

1 Answers  


ORA-13227: SDO_LEVEL values for the two index tables do not match

1 Answers  


Categories