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

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

Question Posted / guest

1 Answers
4404 Views
ABC, I also Faced
E-Mail Answers

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

IMP-00051: Direct path exported dump file contains illegal column length

1 Answers

ORA-29395: cannot set the initial consumer group to string

1 Answers

PLS-00245: Formals used in the 'parameters' clause must appear exactly once

1 Answers

NNL-00954: Hash tables created: number

1 Answers

ORA-32020: SID=* clause needed to modify this parameter

1 Answers

ORA-06018: NETASY: message send failure

1 Answers

DRG-11822: Forbidden

1 Answers

ORA-31458: an internal error occurred

1 Answers

ORA-12550: TNS:syntax error

1 Answers

ORA-25351: transaction is currently in use

1 Answers

ORA-27143: OS system call failure

1 Answers

ORA-13638: The user interrupted the current operation.

1 Answers

For more Oracle Errors Interview Questions Click Here