Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-31653: unable to determine job operation for privilege check

1 Answers  


ORA-00103: invalid network protocol; reserved for use by dispatchers

1 Answers  


ORA-40205: invalid setting name string

1 Answers  


ORA-29884: domain index is defined on the column to be dropped

1 Answers  


ORA-32308: object materialized views must use SELECT *

1 Answers  






PCC-02046: CMD-LINE: Unable to open config file:

1 Answers  


ORA-02767: Less than one request descriptor was allocated per server

1 Answers  


LPX-00218: invalid character ~1u ('~2c')

1 Answers  


TNS-00013: INTCTL: error while performing NS disconnect command

1 Answers  


ORA-30686: no dispatcher accepted TCP/IP connection request

1 Answers  


DRG-12403: template string was not found

1 Answers  


PCC-02129: CMD-LINE: Client supplied static options table is invalid

1 Answers  






Categories