Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sqlldr constants and dates w/timestamp

RE: Sqlldr constants and dates w/timestamp

From: Marley, Darlene <dmarley_at_sfwmd.gov>
Date: Thu, 28 Oct 2004 12:55:52 -0400
Message-ID: <C7703F708B29884F94752985169E7A75248587@EXCHVS01.ad.sfwmd.gov>


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
Received on Thu Oct 28 2004 - 11:56:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US