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 (1571 Views)