Re: ORA-01843: not a valid month

Shailesh wrote:
> Hi Morgan,
>
> Error appears on similar queries not the only query. I agree that it
> should be converted explicitly, but we have inherited this application
> and changing hundreds of queries should not be the only option.
>
> The problem is that error doesn't come continuesly, When everyone
> starts working
> after hour or so it starts coming on few sessions not at all sessions.
>
> Is there any other way to track the same. Please let me know.
>
> Thanks & Regards,
>
> Shailesh
>

Sloppy code. Your code depends on external factors like a date format.
Rewrite all code to use explicit conversions like: to_date('1800.01.01.','YYYY.MM.DD')

Don't ever expect a starting situation to be the same the next time - create your own!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...