Wednesday, September 8, 2021

ORA-14552: Cannot Perform a DDL Commit or Rollback inside a query or DML

You will receive this error when you use COMMIT or ROLLBACK and make sure you don’t use DML in a function to avoid this error.

In case if you need to use COMMIT or ROLLBACK then change your function as autonomous transaction by using “PRAGMA AUTONOMOUS_TRANSACTION" in your function

For Ex:-
CREATE OR REPLACE FUNCTION Function_Autonomous
return number
as
v_number number;
pragma autonomous_transaction;
BEGIN
…………
END;
/

14552, 00000, "cannot perform a DDL, commit or rollback inside a query or DML "
*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.

Thanks & Regards

4 comments:

  1. I was impressed by the good writing. Thank you.
    If you want to know the social graph game, come here!
    Great article, totally what I was looking for.
    고스톱

    ReplyDelete
  2. Wow! This could be one of the most useful blogs we have ever come across on the subject. Actually excellent info! I’m also an expert in this topic so I can understand your effort.
    스포츠토토

    ReplyDelete
  3. Your good writing makes many people feel happy.
    With a lot of writing, you are moved a lot. I also have a lot of interactions with you!
    성인웹툰

    ReplyDelete
  4. I want to feel alive and be happy, saying that I will be a good friend with you, and I will be very happy too. I hope there are always good things and happy days. I always cheered for you.
    Thank you
    토토사이트

    ReplyDelete