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
