6 Replies Latest reply on Dec 13, 2012 1:43 PM by 971895

    SQL*loader error

    969952
      Hi ALl I am getting below error while executing control file.Please have a look.

      SQL*LOADER - 350 syntax error at line 11

      please have a look into the code.
      ---   Data Load ---
      LOAD DATA
      INFILE 'C:\Users\Desktop\States.csv'
      --BADFILE  'C:\Users\Desktop\States.bad'
      --DISCARDFILE 'C:\Users\Desktop\States.dsc'
      INTO TABLE <Table_name>
      fields terminated by ','
      optionally enclosed by '"'
      (
      Territory,
      State Name,
      State Code,
      State Grade ,  ( this is Number data type)
      City Name,
      City GLC, --Number data type ( here I mentioned the data types for your reference)
      County GLC  ---Number
      )
      
      COMMIT;
      
      {code}
      
      Please have a look and do needful.
      
      Thanks.
      
      commit;