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

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

Question Posted / guest

1 Answers
2833 Views
I also Faced
E-Mail Answers

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