3 Replies Latest reply: Jan 25, 2013 3:17 AM by 982895 RSS

    Loading an excel into DB using sqlloader in cmd prompt

    982895
      Hi Everyone,

      Need little help in my requirement. I need to load an excel into a database table and I am doing it though sqlloader in command prompt. Few records are gettng loaded and the few are rejected. And the error is :

      Record 54: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.
      Field in data file exceeds maximum length
      Record 92: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.
      Field in data file exceeds maximum length
      Record 93: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.
      Field in data file exceeds maximum length
      Record 94: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.
      Field in data file exceeds maximum length
      Record 115: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.
      Field in data file exceeds maximum length
      Record 117: Rejected - Error on table SWETHA_TEST, column PARAMETERXML.

      Basically my table structure is as follows:
      PARAMETERDETAILID     NUMBER(6)
      PARAMETERID     NUMBER(6)
      CONTROLTYPE     VARCHAR2(50)
      UNITID     NUMBER(5)
      APPROVEDBY     VARCHAR2(30)
      APPROVED     CHAR(1)
      APPROVALREMARKS     VARCHAR2(100)
      SIUNITID     NUMBER(3)
      CONVERSIONFACTOR     NUMBER
      PARAMETERTYPE     VARCHAR2(10)
      CREATEDDATE     DATE
      CREATEDBY     VARCHAR2(30)
      REASONFORUPDATE     VARCHAR2(50)
      OPTIONS     SYS.XMLTYPE
      PARAMETERXML     SYS.XMLTYPE
      STATUS     NUMBER(1)
      LOCATIONID     NUMBER.....

      Guess Need to increase the length of the XML datatype. If yes, Please help me in doing the same as I have never used this datatype. It will be a great pleasure if I get an answer for this..