Load rows from CSV to table
I have a customised table into which rows from a CSV file have to be loaded.
When I run the sqlload command from UNIx , it creating a log file with the following message. Can anyone suggest how to resolve the error :
CTL file :
OPTIONS(ERRORS=1000000)
LOAD DATA APPEND INTO TABLE hris_temp
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( hris_personid "UPPER(TRIM(:personid))",
last_name "UPPER(TRIM(:lastname))",
first_name "UPPER(TRIM(:firstname))", company_email_address "UPPER( TRIM(:CompanyEmailAddress))"
)
Log file :
SQL*Loader: Release 8.0.6.3.0 - Production on Mon Jun 13 10:01:33 2011
(c) Copyright 1999 Oracle Corporation. All rights reserved.