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

ORA-36722: (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.

1 Answers  


LPX-00007: unexpected end-of-file encountered

1 Answers  


KUP-04038: internal error: string

1 Answers  


ORA-15116: invalid combination of ALTER DISKGROUP options

1 Answers  


NID-00129: Invalid DBID for datafile "string", expecting number, found number

1 Answers  






ORA-16553: the Data Guard broker process (DMON) failed to shutdown

1 Answers  


ORA-31605: the following was returned from string in routine string: LPX-number: string

1 Answers  


ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations

1 Answers  


ORA-12023: missing index on materialized view "string"."string"

1 Answers  


ORA-22931: MOVE of nested table to a different tablespace not supported

1 Answers  


ORA-01928: GRANT option not granted for all privileges

1 Answers  


ORA-13375: the layer is of type [string] while geometry inserted has type [string]

1 Answers  


Categories