Database Extract fails with "ORA-01453: SET TRANSACTION must be first statement of transaction"

(Doc ID 1916248.1)

Last updated on JULY 11, 2017

Applies to:

Siebel CRM - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.

Symptoms

When Database Extract (DbXtract) was started, it failed at "Part 4: Deleting from temporary tables" with the following information.

 

  Part 4: Deleting from temporary tables...

SQLError    Statement   0     0000000853e90868:0      2014-08-11 11:06:03     SQL Statement:

BEGIN loop delete from SIA81.S_DOCK_INITM_01 where rownum < 2000 and NODE_ID = '1-9I6';set transaction use rollback segment ta; exit when SQL%rowcount = 0;commit;end loop;commit; END;

DBCLog      DBCLogError 1     0000000853e90868:0      2014-08-11 11:06:03      [DataDirect][ODBC Oracle driver][Oracle]ORA-01453: SET TRANSACTION must be first statement of transaction

ORA-06512: at line 1



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms