TOracleDirectPathLoader

[dgsmith]

I'm trying to use TOracleDirectPathLoader, following the example in the help file. I'm processing multiple data files; the first goes fine, and the second goes fine until the Finish method is called, when I get 'ORA-00600: internal error code, arguments: [ktssinseg1], [], [], [], [], [], [], []'. The records from the second file are in the table. The Oracle trace file shows

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktssinseg1], [], [], [], [], [], [],
D[]Oracle\admin\dor_prod\udump>xvi cla.out
Current SQL statement for this session:
INSERT INTO W2_TAPE.employees (YEAR,TAPE_NUMBER,TAX_YEAR,EIN,SSN,LAST_NAME,FIRST
_NAME,ADDRESS_1,ADDRESS_2,CITY,STATE,ZIP,WAGES,WITHHOLDING) VALUES (NULL,NULL,NU
LL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)

Any help would be much appreciated.

------------------
David Smith

 

[Marco Kalter]

The only similar Oracle errors I could find were related to parallel DML. I'm not sure if this is the same problem, there is no reference to direct path loading. To fix this you probably need to contact your Oracle support representative.

------------------
Marco Kalter
Allround Automations

 

[Dmitry_A]

Actually, the problem realy exists if we use Orcale 9.2.0.6 (9.2.0.5 - everything is OK). Make sure, that before Finish method there are not any commits within corresponding OracleSession. If so, replace it - and the problem will be 'fixed' -)