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.