ORA-00034 Error When Commit In Curren Session

This co-worker ask me about the next error last morning when I was executing a pl/sql script;

 
BBDD_12> SELECT DBMS_METADATA.GET_DDL ('TABLESPACE','F_MOVISTAR_DAT') FROM DUAL;
ERROR:
ORA-00034: no se puede ROLLBACK en la sesión PL/SQL actual
ORA-06512: en "SYS.KUPU$UTILITIES_INT", línea 735
ORA-00034: no se puede COMMIT en la sesión PL/SQL actual
ORA-06512: en "SYS.DBMS_METADATA", línea 6069
ORA-06512: en "SYS.DBMS_METADATA", línea 8666
ORA-06512: en línea 1

I tell him it is a “logical lock” that I use when to execute stored procedure or anonymous pl/sql of mine or other persons and not perform a commit in an irresponsible way. In my login.sql I have the next entry;

alter session disable commit in procedure;

To solve it you must only switch it to enable;

BBDD_12> ALTER SESSION ENABLE COMMIT IN PROCEDURE; 

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s