dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Problems with select expression in SQL*Loader. - Oracle Tools

This is a discussion on Problems with select expression in SQL*Loader. - Oracle Tools ; Evening, everyone! Got this "SQL*Loader-930 error parsing insert statement for SELTEST.ID ORA-00936: missing expression" while tried to load a data to my DB . Could anyone help me with that stuff? My ctl file LOAD DATA INFILE '1.csv' INTO TABLE ...


Home > Database Forum > Oracle Database > Oracle Tools > Problems with select expression in SQL*Loader.

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 05-23-2008, 05:50 AM
Database Newbie
 
Join Date: May 2008
Posts: 1
Krovatkin is on a distinguished road
Default Problems with select expression in SQL*Loader.

Evening, everyone!
Got this
"SQL*Loader-930 error parsing insert statement for SELTEST.ID
ORA-00936: missing expression"
while tried to load a data to my DB.

Could anyone help me with that stuff?

My ctl file

Quote:
LOAD DATA
INFILE '1.csv'
INTO TABLE seltest
FIELDS TERMINATED BY ';'
(id "select id from z#px where c_cns_rec#no=:id", string, id2)
csv file

Quote:
807638;БАЛГАБАЕВА БОТАГОЗ АМАНТАЕВНА;29
807643;ШАКЕНОВА ГУЛЬМИРА ТЕМИРБЕКОВНА;33
807685;КЕНЕСАРЫ МЕДЕТ ТОКТАРБЕКОВИЧ;23
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 02:45 PM.