I am trying to upload a xml file using SQLLoader to an Oracle table but the file is not getting uploaded.
PFB the error I am getting:
Record 1: Rejected - Error on table XML_FILES_TEST.
ORA-03113: end-of-file on communication channel
Process ID: 8364
Session ID: 615 Serial number: 17863
SQL*Loader-604: Error occurred on an attempt to commit
ORA-03114: not connected to ORACLE
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Table XML_FILES_TEST:
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Table (XML_FILES_TEST) contain the following fields :
"FILENAME" VARCHAR2(1000 BYTE),
"FILECONTENT" "XMLTYPE" (binary format)
The control file :
LOAD DATA
INFILE xmlFileName.txt
INTO TABLE XML_FILES_test APPEND
fields terminated by ','
(
filename CHAR(4000),
filecontent LOBFILE(filename) terminated by eof
)
xmlFileName.txt contains path to different xml files.
I am able to upload certain files but not others.
I compared the files but was not able to find any error pattern.
sqlldr version : SQL*Loader: Release 11.1.0.6.0
oracle version : Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
Could you please let me know the possible reason for this issue?
Thanks in Advance .