ORA-01801 date format too long .... ?


I run an client\server application called PVCS. The server is an NT server running an Oracle 8.7.1 runtime database. The clients connect to this via a GUI (Oracle Forms).
Occassionally (every 3 months or so) they get the following error message:

1019-DBIO: ORACLE Error occurred
SQL-0438(00EAF460)ORA-01801: date format is too long for internal buffer.

The only way to solve this is to re-boot the client PC.
I know what the Oracle docs say the error is about, but was wondering if anybody explain it a bit more, especially why re-booting seems the only solution. Is the application wrong, or prehaps the OS, or even the machine heap. I am guessing here - any help would be appreciated.



A good guess\solution gets points.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Generally this error occurs when you have some really long literals in date field. Try looking at the code and your client machine setting may be its converting the date field value.  I am not sure but I remember there was some oracle bug also related to this problem. Go to metelink and see if you can find some info.
Error goes away aftet rebooting because you clear the cache and that eliminates the problem.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alistair_WilliamsAuthor Commented:
Thanks for your help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.