DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01843: not a valid month

  1. #1
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174

    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.

    wierd.

    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?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2005
    Posts
    158
    "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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width