ORA-00603 And ORA-00034 Erros Creating Partitioned Table

Today, creating a partitionated talbe I get the following error (excerpt from alert.log);

Mon Dec 01 10:12:37 2014
Errors in file /utiles/prod/sibo/diag/rdbms/osis1/OSIS1/trace/OSIS1_ora_26439.trc (incident=149339):
ORA-00603: la sesi\363n de ORACLE Server ha terminado debido a un error fatal
ORA-00034: no se puede ROLLBACK en la sesi\363n PL/SQL actual
Incident details in: …

The problem here is that “COMMIT IN PROCEDURE IS DISABLE” at level session. IF I execute the next command;

alter session enable commit in procedure;

It is curious because it fails in 11.2 version, the same testcase in 10.2.0.4.0 works fine.

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