ORA-00034 Error -> Cannot COMMIT or ROLLBACK in Current PL/SQL Session

By Santhosh N

This explains the oracle error, ORA-00034 in detail, the possible reason(s) and steps to solve the same in Oracle Database.

Oracle Error: ORA-00034

Description: Cannot COMMIT or ROLLBACK in Current PL/SQL Session.

Reason(s) for this Oracle error: This error will be raised when an attempt is made to issue a COMMIT or ROLLBACK command from PLSQL Procedure, Function or Package where in which these are disabled for the current session by using the following command:
ALTER SESSION DISABLE COMMIT IN PROCEDURE

Possible steps to solve this error:
1) Enable COMMIT and/or ROLLBACK whichever you want to use for the current session. This can be done by the following command
ALTER SESSION ENABLE COMMIT IN PROCEDURE
2) Make sure not to use COMMIT or ROLLBACK command in the PLSQL Procedure, Function or Package when they are disabled.

Related FAQs

This explains the oracle error, ORA-00033 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00032 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00031 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00030 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00029 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
This explains the oracle error, ORA-00028 in detail, the possible reason(s) and steps to solve the same in Oracle Database.
ORA-00034 Error -> Cannot COMMIT or ROLLBACK in Current PL/SQL Session  (1503 Views)