Home -> Usenet -> comp.databases.oracle -> NLS_DATE_FORMAT with SOL Loader

NLS_DATE_FORMAT with SOL Loader

From: fareeda <fareeda_at_pspl.co.in>
Date: 23 Jun 2003 06:48:58 -0700
Message-ID: <c6d78d84.0306230548.3c54cad2_at_posting.google.com> 






hi,



I am trying to set the NLS_DATE_FORMAT to be used by 'sqlldr' (Since
my date format is not the default)


But it fails to take effect.



Also, I cannot set the DATE format in the column list in the sqlldr
control file since it is an autogenerated.
The control file is generated internally and passed to sqlldr.



I tried this:

1) export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
2) checked in ENV and it seems to be there
3) run sqlldr to load the data which is present in above format





Result: no data is loaded, giving DATA error messages.



Is there a way to set the date format to be used by sqlldr (other than
in control file)



Any pointer would help.


Thanks


Fareeda
Received on Mon Jun 23 2003 - 15:48:58 CEST












Original text of this message