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:-
return number
v_number number;
pragma autonomous_transaction;

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


  1. 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!

  2. 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.

  3. 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.