From oracle-l-bounce@freelists.org Thu Oct 28 11:56:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9SGu9Q22433 for ; Thu, 28 Oct 2004 11:56:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9SGu7I22405 for ; Thu, 28 Oct 2004 11:56:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1A20773178F; Thu, 28 Oct 2004 12:02:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21402-59; Thu, 28 Oct 2004 12:02:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4D9E872CFFE; Thu, 28 Oct 2004 12:00:57 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Sqlldr constants and dates w/timestamp Date: Thu, 28 Oct 2004 12:55:52 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Sqlldr constants and dates w/timestamp Thread-Index: AcS9Cdhd65efdrP2Rn+IfWyKzCFL6QABLotg From: "Marley, Darlene" To: "Ganesh Raja" Cc: X-DCC-SFWMD-Metrics: mx4 1123; Body=1 Fuz1=1 Fuz2=1 X-Scanned-By: MIMEDefang 2.37 X-archive-position: 11653 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dmarley@sfwmd.gov Precedence: normal Reply-To: dmarley@sfwmd.gov X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@gmail.com] Sent: Thursday, October 28, 2004 12:19 PM To: Marley, Darlene Cc: oracle-l@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 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