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-29959: error in the execution of the string routine for one or more of the index partitions

1 Answers  


ORA-24501: invalid UTF16 string passed in

1 Answers  


NID-00331: The following datafiles are disabled:

1 Answers  


PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

1 Answers  


ORA-00603: ORACLE server session terminated by fatal error

2 Answers  






PLS-00131: Pragma string expects 2nd argument to be a procedure

1 Answers  


RMAN-08048: channel string: starting incremental level string datafile backupset

1 Answers  


ORA-37014: (XSACQUIRE_ACQUIRED) Object workspace object is already acquired.

1 Answers  


ORA-29809: cannot drop an operator with dependent objects

1 Answers  


ORA-24374: define not done before fetch or execute and fetch

2 Answers  


TNS-01182: Listener rejected registration of service "string"

1 Answers  


QSM-01102: materialized view, string, requires join back to table, string, on column, string

1 Answers  


Categories