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

LSX-00271: invalid character "~c" in hex-encoded binary

1 Answers  


ORA-14637: cannot merge a subpartition with itself

1 Answers  


NNL-00205: Reload check occurs in string

1 Answers  


IMG-00606: unable to access image data

1 Answers  


KUP-04025: field extends beyond end of record

1 Answers  






ORA-30041: Cannot grant quota on the tablespace

1 Answers  


ORA-27372: length of action and arguments exceeds platform limit string

1 Answers  


VID-00706: unsupported or corrupted input format

1 Answers  


LSX-00172: "~S" is not a valid restriction of "~S"

1 Answers  


ORA-07260: spdcr: wait error.

1 Answers  


ORA-01145: offline immediate disallowed unless media recovery enabled

1 Answers  


DRG-11445: rowid value is invalid: string

1 Answers  


Categories