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-23443: missing template parameter

1 Answers  


ORA-13627: Setting of parameter string is disallowed until the task is reset.

1 Answers  


RMAN-08115: channel string: restoring SPFILE

1 Answers  


EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  


KUP-04058: unrecoverable error occurred, operation aborted.

1 Answers  






ORA-36380: (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.

1 Answers  


ORA-29876: failed in the execution of the ODCIINDEXDELETE routine

2 Answers  


RMAN-06494: %s = string is out of range (string-string)

1 Answers  


ORA-01451: column to be modified to NULL cannot be modified to NULL

1 Answers  


ORA-01110: data file string: 'string'

1 Answers  


ORA-32806: value for string is too long, maximum length is string

1 Answers  


NID-00604: No control files found in database

1 Answers  


Categories