1 Reply Latest reply: Jun 12, 2014 10:18 AM by Jason_(A_Non) RSS

    XML file not getting uploaded using SQL Loader

    a443deb1-6d77-44ab-b5c5-559ad247479c

      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 .