Problems with select expression in SQL*Loader.

This is a discussion on Problems with select expression in SQL*Loader. within the Oracle Tools forums in Oracle Database category; 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 Database. Could anyone help me with that stuff? My ctl file 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 807638;БАЛГАБАЕВА БОТАГОЗ АМАНТАЕВНА;29 807643;ШАКЕНОВА &#...

Go Back   Database Forum > Oracle Database > Oracle Tools

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 05-23-2008, 06:50 AM
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 Database.

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 04:28 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.