In this post, you’ll learn more about the Oracle ErrorORA-30512: cannot modify string.string more than once in a transaction with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-30512: cannot modify string.string more than once in a transaction
Reason for the Error ORA-30512: cannot modify string.string more than once in a transaction
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.
How to fix the Error ORA-30512: cannot modify string.string more than once in a transaction ?
You can fix this error in Oracle by following the below steps
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.