Print Thread
TOracleDirectPathLoader
#1068 10/10/00 07:42 PM
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
D
dgsmith Offline OP
Member
OP Offline
Member
D
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
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


David Smith
Re: TOracleDirectPathLoader
#1069 10/12/00 09:05 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
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


Marco Kalter
Allround Automations
Re: TOracleDirectPathLoader
#1070 08/22/05 10:08 PM
Joined: Aug 2005
Posts: 1
D
Member
Offline
Member
D
Joined: Aug 2005
Posts: 1
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' -)


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.092s Queries: 13 (0.062s) Memory: 2.5046 MB (Peak: 3.0430 MB) Data Comp: Off Server Time: 2024-05-18 09:36:40 UTC
Valid HTML 5 and Valid CSS