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

8 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
  5. Love to read it, waiting for More New Update and I Already Read your Recent Post it's Great. Thank you for sharing useful information. If you like to Know Azerbaijan Medical Journal Visit our website for More Medical Science Information.

    ReplyDelete
  6. Buying a business does not have to be a complicated endeavor when the proper process and methodology is followed. In this article, we outline eleven specific steps that should be adhered to when buying a business and bank financing is planned to be utilized. 메이저토토사이트추천

    ReplyDelete
  7. Higher Secondary Certificate, also known as HSC or Intermediate or 12th Class Examination, is a Public Examination taken by Students of intermediate College in India in All States, Central Board of Secondary Education (CBSE) is a National Level Board of Education in India for Government and Private Collages, Parent organization Ministry of Human Resource Development. CBSE has asked All Collages Affiliated to follow only NCERT Curriculum. 12th Class Question Paper 2023 Central Board Conducts All State Final Examinations for 12th Class Every year in the month of March, Central Board Every year Announce 12th Class Model Paper 2023 for Higher Secondary Certificate Level Examinations Academic year 2023, Going Through These HSC Model Paper 2023 not only helps to prepare the right plan to write a Perfect Exam but also to Assess your Preparation level by knowing the weak areas.

    ReplyDelete
  8. Uttarakhand Board will announce the Class 10th Examination Previous Question Paper 2023 very soon. Uttarakhand Board Students are waiting for Uttaranchal Board 10th Previous Question Paper 2023 for High School Class Xth UK Matric Model Paper 2023 examination Class 10th Model Question Paper 2023, UBSE Class Xth Previous Question Paper 2023, Uttarakhand Board 10th Model Question Paper 2023 The Uttarakhand Class 10th exam Previous Question Paper 2023 will available on its official website at UA Previous Question Paper 2023 Dear all Students visit given below official link and check your Uttarakhand Board Class 10th Previous Question Paper 2023 whenever published officially. Direct link of Uttarakhand Board High School 10th Class Previous Question Paper 2023 will available here soon.

    ReplyDelete