Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00034 Error


Error:

ORA-00034: cannot COMMIT or ROLLBACK in current PL/SQL session

Cause:

You tried to issue a COMMIT or ROLLBACK command from a PLSQL function, procedure, or package. However, COMMIT and ROLLBACK have been disabled with the following command:

ALTER SESSION DISABLE COMMIT IN PROCEDURE

Action:

The options to resolve this Oracle error are:
  1. Do not issue a COMMIT or ROLLBACK command from your PLSQL function, procedure, or package while disabled.
  2. Enable COMMIT or ROLLBACK for this PLSQL session.