Re: Loading Constant Date

Paul,

I doubt if there is any other option but to set the NLS_LANG and NLS_DATE parameters at a session level. Since DIRECT does bypass the SQL engine, I doubt if one can make use of any SQL functions in the scripts.

Regards
Bhooshan

pcrock_at_lycos.com (Paul Crocker) wrote in message news:<960f9005.0208211214.a0679f0_at_posting.google.com>...
> Does anyone know how to load a constant date using Oracle8i SQL*Loader
> direct-path? have a date that includes a time element. Have tried
> "to_date('080102.13:15:27','mmddyy.hh24:mi:ss')", but that only works
> in conventional. Also have tried numerous permutations, including the
> "constant" keyword. No luck. Cannot use sysdate. Am aware that I
> can change the default NLS date format, but hoping there is a simple
> SQL*Loader solution. Has to be a common problem. An example of my
> control file is as follows:
>
> UNRECOVERABLE
> LOAD DATA
> truncate
> INTO TABLE cust
> SORTED INDEXES (idx1_cust)
> FIELDS TERMINATED BY '$'
> TRAILING NULLCOLS
> (
> CUST_NUM,
> MGR_NUM,
> AAVR_ID,
> ISSD_DT DATE "mm/dd/yyyy hh24:mi:ss",
> STATUS,
> NM,
> EXT_DT "to_date('080102.13:15:27','mmddyy.hh24:mi:ss')"
> )
>
> SQL*Loader: Release 8.1.7.4.0 - Production on Wed Aug 21 15:29:43 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL*Loader-417: SQL string (on column EXT_DT) not allowed in direct
> path.
>
> Thanks,
>
> Paul
Received on Thu Aug 22 2002 - 07:46:21 CEST