Home » RDBMS Server » Server Utilities » What is wrong with this
What is wrong with this [message #70109] Mon, 15 April 2002 15:22 Go to next message
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
Re: What is wrong with this [message #70117 is a reply to message #70109] Tue, 16 April 2002 11:22 Go to previous messageGo to next message
Niranjan
Messages: 34
Registered: June 2001
Member
Never mind, just fat fingers.
Re: What is wrong with this [message #70607 is a reply to message #70117] Fri, 05 July 2002 09:46 Go to previous message
Sukhy
Messages: 1
Registered: July 2002
Junior Member
What was wrong? I am getting the exact same error but
am unable to figure it out.

Thanks,
Sukhy
Previous Topic: migration
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Mon Dec 23 07:06:42 CST 2024