1 Reply Latest reply on Oct 14, 2013 6:22 PM by TSharma-Oracle

    SQL*Loader: Error on table CZD01T00, column PSNTO_TCNC_PCDN. Column not found before end of logical record

    Gianfri

      Hi all,

      I am asking your help because I have come to a dead end.

       

      I am trying to load a CSV file into a table via SQL*Loader, but I am getting the error message in the title: "Error on table CZD01T00, column PSNTO_TCNC_PCDN. Column not found before end of logical record".

       

      But the colum "PSNTO_TCNC_PCDN" is found both in the table definition, the CSV file (first row of the file has column names) and the SQL*Loader control file.

       

      The question is: how can I fix this? I don't know where else to search for a mistake.

       

      If someone find it userful, I can post the DESCription of the table "CZD01T00", the control file and the error log. Maybe the first few rows of the csv file.

       

      Thanks in advance,

       

      Gianfranco

       

      P. S.

       

      I am working with Oracle 11g express in a lab environment. Once fixed, the job is expected to run against a "full" Oracle 11g in production environment.

       

      EDIT fixed typos.