Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: SQL *LOADER ERROR in .csv format

    Hi All,
    Iam having problem in loading data from .csv format file to oracle tables using sql*loader.
    My table:

    Table test(col1 number(10), col2 clob);

    the .ctl file :
    LOAD DATA
    INFILE 'c:\test.csv'
    INTO TABLE xp_clinical_text_x
    FIELDS TERMINATED BY ','
    TRAILING NULLCOLS
    (TEXT_ID,CLINICAL_TEXT CHAR(30000) TERMINATED BY WHITESPACE)

    The log file :
    Record 17014: Rejected - Error on table, column TEXT_ID.
    ORA-01722: invalid number

    Record 17016: Rejected - Error on table, column TEXT_ID.
    ORA-01722: invalid number

    The data file looks like this:
    100,"Maintenance dose: Initial PO doses may be titrated upward"
    101,"Twenty-four hour control with once daily dosing is achieved by "

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    Are you sure you want the 'TERMINATED BY WHITESPACE' where it is?

    Try:
    Code:
    LOAD DATA
    INFILE 'c:\test.csv'
    INTO TABLE xp_clinical_text_x
    FIELDS TERMINATED BY ','
    OPTIONALLY ENCLOSED BY '"'
    TRAILING NULLCOLS
      ( TEXT_ID,
        CLINICAL_TEXT 
      )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •