ORA-01843: not a valid month
OK people...hope this is an easy one for y'all.
This just came up today. The System been running fine and no changes has been made, but all of a sudden, users are complaining they are getting this error from querying a table.
When I try to do a select * from table; from sqlplus, the records are returned but at the end of the output, there's the error! - THE ERROR APPEARS AT THE END OF THE RESULTS.
What's more wierd is that this particular table has NO date columns at all. Although it does have columns of varchar type that appear to hold date values.
Can someone explain this error in this situation?
Here's a guess -- they're accessing a view on top of the table, and the view is performing a date conversion. Someone changed the default date format on the machine, and the to_date() in the view has no specific format picture.
"the end of the output, there's the error! "
Sort of reminds me about the age-old question, when you look for something, why do you find it in the last place you look.
Answer, because then you stop looking.
The error comes at the end of the output because, when it hits the error, it stops processing.
Click Here to Expand Forum to Full Width