This discussion is archived
3 Replies Latest reply: Jan 25, 2013 1:17 AM by 982895 RSS

Loading an excel into DB using sqlloader in cmd prompt

982895 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points