| Default Date in SQL Loader [message #69075] |
Wed, 24 October 2001 13:48  |
Sree
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
I am trying to put a default date for a field in a table using sqlldr80. it's giving error "ORA-01861: literal does not match format string".
using the sysntax like
"XYZ_DATE CONSTANT '03152002' ,"
Please help.
----------------------------------------------------------------------
|
|
|
|
| Re: Default Date in SQL Loader [message #69080 is a reply to message #69075] |
Thu, 25 October 2001 01:54  |
Chella
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
*Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra whitespace.
*Action: Correct the format string to match the literal.
You can find more help if you search for ORA-01861 error on Oracle forums and sites.
HTH
Chella
----------------------------------------------------------------------
|
|
|
|
| Re: Default Date in SQL Loader [message #69083 is a reply to message #69075] |
Thu, 25 October 2001 08:26 |
Sree
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
I found the solution for this problem my self. The problem is Oracle expecting only default format as "DD-MMM-YY" as input. I changed my syntax to
"XYZ_DATE CONSTANT '15-MAR-02', " it worked. Thanks for the help.
Sree
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
