My Oracle Support Banner

Database Extract fails with "ORA-01453: SET TRANSACTION must be first statement of transaction" (Doc ID 1916248.1)

Last updated on DECEMBER 12, 2018

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.