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,
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.
Cause: The logical record ended before all specified fields were found.
Action: If the missing fields should be loaded as null, use the TRAILING NULLCOLS clause. Otherwise, correct the data.