OraFAQ Forum: Server Utilities » What is wrong with this

Home » RDBMS Server » Server Utilities » What is wrong with this

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What is wrong with this [message #70109]

Mon, 15 April 2002 15:22

Niranjan
Messages: 34
Registered: June 2001

Member

I am using the following SQL*Loader control file to load a Sybase data file into Oracle8i. A sample of the data and my control file is as follows:
=====================
A&#124Highest Inventory Usageә�_.0&#124install&#124install&#124Oct 5 1994 10:05:44:226PM&#124Oct 5 1994 10:05:44:226PM
====================
load data
infile 'abc_codes.txt'
truncate
into table ciim.abc_codes
fields terminated by "&#124"
(
abc_code char
, abc_desc char
, abc_rank integer external
, abc_percentage decimal external
, created_by char
, updated_by char
, create_date "to_date(replace(:create_date,substr(:create_date,-6,4),"),'MON DD YYYY hh:mi:ssAM')" date
, record_date "to_date(replace(:record_date,substr(:record_date,-6,4),"),'MON DD YYYY hh:mi:ssAM')" date
)
==================================

I get the following error
=========================
SQL-Loader-350: Syntax error at line 13.
Expecting keyword INFILE, keyword INTO or end of file, found ",".
replace(:create_date,substr(:create_date,-6,4),"),'MON DD YYYY hh:mi:s

The error indicator points to the comma after string 6,4),")

Can someone help me out?

Thanks,

Niranjan

Report message to a moderator