ORA-01721: USERENV(COMMITSCN) invoked more than once in a
transaction



ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction..

Answer / guest

Cause: The USERENV('COMMITSCN') function can only be used
once in a transaction.

Action: Re-write the transactioin to use
USERENV('COMMITSCN') only once

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00547: user information retrieval failed

1 Answers  


ORA-13404: invalid ultCoordinate parameter

1 Answers  


ORA-16762: Invalid database state

1 Answers  


ORA-16092: dependent archive log destination is not active

1 Answers  


ORA-16035: missing required keyword string

1 Answers  






ORA-25109: standby lock name space has illegal character 'string'

1 Answers  


DRG-51019: unable to open or illegal format for fuzzy match data file: string

1 Answers  


ORA-16591: unknown field "string" in document

1 Answers  


LFI-00119: Unable to Abort an Unprotected file.

1 Answers  


LSX-00340: improper namespace value for the imported element

1 Answers  


ORA-03007: obsolete feature

1 Answers  


ORA-09709: soacon: failed to accept a connection.

1 Answers  


Categories