ORA-30512: cannot modify string.string more than once in a
transaction



ORA-30512: cannot modify string.string more than once in a transaction..

Answer / guest

Cause: An attempt was made to modify an object more than
once in a transaction. This error is usually caused by a DDL
statement that fires a system trigger that tries to modify
the same object. It can also happen when an attempt is made
to perform more than one DDL operation on a queue table in
the same transaction without issuing a commit between
operations.

Action: Do not create system triggers that might modify an
already modified object. Also, do not specify more than one
DDL operation on a queue table in the same transaction.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported

1 Answers  


ORA-16765: Physical apply service unexpectedly online

1 Answers  


AMD-00120: dimension #string: analytic workspace dimension name not specified

1 Answers  


ORA-31022: Element not found

1 Answers  


ORA-16122: applying large dml transaction at SCN string

1 Answers  


PLS-00705: exception 'string' used in expression requiring return type

1 Answers  


LPX-00249: invalid external ID declaration

1 Answers  


DRG-11620: URL store: thread operation error

1 Answers  


PLS-00424: RPC defaults cannot include Package State

1 Answers  


ORA-02044: transaction manager login denied: transaction in progress

1 Answers  


DRG-50701: error in listener.get_cmd()

1 Answers  


ORA-25247: %s is not a recipient of specified message

1 Answers  


Categories