Oracle Error ORA-00034

Cause:An attempt was made to issue a commit or rollback from a PL/SQL object (procedure, function, package) in a session that has this disabled (by 'alter session disable commit in procedure')

ALTER SESSION DISABLE COMMIT IN PROCEDURE

Action: Enable commits from PL/SQL in this session, or do not attempt to use commit or rollback in PL/SQL when they are disabled in the current session.

For example:

alter session disable commit in procedure;

>exec view.refresh( 'TT' );

* ERROR at line 1: ORA-00034: cannot COMMIT in current PL/SQL session ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860 ORA-06512: at "SYS.DBMS_SNAPSHOT", line3 ORA-06512: at line 1