Home » RDBMS Server » Server Utilities » Re: Converting Date data in SQL Loader
Re: Converting Date data in SQL Loader [message #368277] Wed, 25 October 2000 09:02
Shanthi
Messages: 8
Registered: October 2000
Junior Member
Thanks. It Works

I have tried the combinations of substr/replace etc, but I haven't realized my mistake until I saw your posting. I forgot to place a semicolon( ":") before a variable name

,vestek_change_date "to_date(replace(vestek_change_date,substr(vestek_change_date,-6,4),''),'MON DD YYY
Y hh:mi:ssAM')"

Since the SQLLoader messages are not user friendly
Record 1: Rejected - Error on table ACCOUNT, column VESTEK_CHANGE_DATE.
ORA-00984: column not allowed here

, I never realized it. Thought something wrong with the logic I was using, wasted whole day yesterday. Thanks,

Shanthi
Previous Topic: Export Error EXP-00003
Next Topic: SQL * Loader Error
Goto Forum:
  


Current Time: Thu May 19 22:33:23 CDT 2022