Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load Data from .csv file problems

295545Nov 20 2006 — edited Nov 20 2006
Hi There


I am usimg sql loader first time and run on some problems
I am trying to upload data from .csv file into some temporary table. First row in that .csv file are column names.
Every time i get the same error : ERROR at line 1:
ORA-00900: invalid SQL statement - for which i tripple checked all table columns
Here is my command :
LOAD DATA INFILE 'c:\Proj\Leads.csv'
INTO TABLE g_lead
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CONTACT_NAME
,COMPANY_NAME
,ADDRESS
,CITY
,PROVINCE_CODE
,POSTAL_CODE
,PHONE
,FIRST_NAME_LAST_NAME
,FAX_NUMBER
,LOC_SALES_VOLUME_CODE1
,ACTUAL_CORPORATE_EMP_SIZE
,SECONDARY_ADDRESS
,SECONDARY_CITY
,SECONDARY_PROVINCE_CODE
,SECONDARY_POSTAL_CODE
,LOOKUPSIC
,LOOKUPNAICS
,LOOKUPDUNS
,LOOKUPNAICS3
,LOOKUPNAICS3DESCRIPTION
,LOOKUPNAICSDESCRIPTION
)




Can someone help me what is the problem here . Table columns are correct. I also tried to remove from .csv file first row , which is the column names.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2006
Added on Nov 20 2006
17 comments
1,907 views