Sqlldr constants and dates w/timestamp

Maybe someone can save my bloody head from beating it against the wall.
 

I'm using sqlldr 8.1.7 and I'm trying to load a file that needs
supplemental constant values:

 

OPTIONS(SKIP=19)

LOAD DATA

INFILE 'WCA1MESO.csv'

APPEND

INTO TABLE erid.loaddiel

FIELDS TERMINATED BY "," Optionally enclosed by '"' TRAILING NULLCOLS

(

sonde               CONSTANT "33214",

deploydepth     CONSTANT ".64",

retrievaldepth  CONSTANT ".63",

deploydatetime  CONSTANT "04-OCT-2004 14:00:00", -- date format
DD-MON-YYYY HH24MISS

 

blah, blah,blah

 

I've set my environment variable NLS_DATE_FORMAT to 'DD-MON-YYYY
HH24MISS', but it still pukes on deploydatetime with the error
"ORA-01830: date format picture ends before converting entire input
string"

 

Any ideas?

 

TIA

Bloody in FL.

 

 

 

I

 


--
http://www.freelists.org/webpage/oracle-l

Other related posts: