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
4318 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

ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers

RMAN-08007: channel string: copied datafilecopy of datafile string

1 Answers

PCC-00129: Option "string" must be given

1 Answers

TNS-12616: TNS:no event signals

1 Answers

ORA-09701: scnfy: maximum number of processes exceeded

1 Answers

ORA-16203: Unable to interpret skip procedure return values

1 Answers

ORA-16566: unsupported document type

1 Answers

ORA-09201: sfcopy: error copying file

1 Answers

TNS-01400: Instance "string" has number handlers.

1 Answers

ORA-15019: discovered duplicate path 'string' for 'string'

1 Answers

RMAN-08158: executing script: string

1 Answers

ORA-24809: amount specified will not fit in the lob buffers

1 Answers

For more Oracle Errors Interview Questions Click Here