Database Error Messages

OCI-30512

cannot modify string.string more than once in a transaction

Cause

An attempt was made to modify an object more than once in a transaction. This error is usually caused by a Data Definition Language (DDL) statement that generates a system trigger which tries to modify the same object. This error 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.