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-12638: Credential retrieval failed

1 Answers  


ORA-01320: Invalid Logminer dictionar attribute

1 Answers  


TNS-01303: ns main err code: number

1 Answers  


TNS-02405: GMS call failed, check GMS logs.

1 Answers  


ORA-19607: %s is an active controlfile

1 Answers  






ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

1 Answers  


ORA-13628: Insufficient privileges to access the task belonging to user string

1 Answers  


ORA-22952: Nested Table equality requires a map method on the element ADT

1 Answers  


ORA-12554: TNS:current operation is still in progress

1 Answers  


ORA-26517: materialized view control entry for 'string.string' was not found

1 Answers  


ORA-28027: privileged database links may be used by global users

1 Answers  


ORA-13341: a line geometry has fewer than two coordinates

1 Answers  


Categories