1 Reply Latest reply on Jun 12, 2014 3:18 PM by Jason_(A_Non)

    XML file not getting uploaded using SQL Loader


      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 :


        "FILECONTENT" "XMLTYPE"    (binary format)


      The control file :

      INFILE xmlFileName.txt

      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

      oracle version : Oracle Database 11g Enterprise Edition Release - 64bit Production


      Could you please let me know the possible reason for this issue?


      Thanks in Advance .