RE: Sqlldr constants and dates w/timestamp

Good catch Raja. Removed the ":" and still got the same error. Any other ideas?
Still bloody in FL.

-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com] Sent: Thursday, October 28, 2004 12:19 PM To: Marley, Darlene
Cc: oracle-l_at_freelists.org
Subject: Re: Sqlldr constants and dates w/timestamp

Just a Thought here ..

U have Got ":" in the constrant but the value uh have said as the NLS_DATE_FORMAT does not havethe ":" in them...

:)

On Thu, 28 Oct 2004 12:15:04 -0400, Marley, Darlene <dmarley_at_sfwmd.gov> wrote:
> 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=3D19)
>
> 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
>

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