ORA-14552: cannot perform a DDL, commit or rollback inside a
query or DML



ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML..

Answer / guest

Cause: DDL operations like creation tables, views etc. and
transaction control statements such as commit/rollback
cannot be performed inside a query or a DML statement.

Action: Ensure that the offending operation is not performed
or use autonomous transactions to perform the operation
within the query/DML operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


ORA-01515: error dropping log group string: no such log

1 Answers  


RMAN-06083: error when loading stored script string

1 Answers  


DRG-10708: invalid class id string for preference string

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  






IMG-00561: input format does not support channel selection

1 Answers  


DRG-11844: HTTP Version Not Supported

1 Answers  


ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

1 Answers  


ORA-16788: Unable to set one or more database configuration property values

1 Answers  


ORA-16062: DGID from standby not in Data Guard configuration

1 Answers  


ORA-27040: file create error, unable to create file

1 Answers  


PLS-00520: MAP methods must be declared without any parameters other than (optional) SELF.

1 Answers  


Categories