Jump to content


Member Since 10 Jul 2003
Offline Last Active Jul 25 2003 07:56 AM

Topics I've Started

Weird numeric conversion error?

10 July 2003 - 03:01 AM

Hi all

Platform: PROIV v 5.0r109 on Oracle 8.1.7

We've recently been experience a strange problem. On one of our larger tables, we get a numeric conversion error at random times - we have tracked the problem to be related to a date in the table, which has been set to 0 from PROIV (and thus appears as 31/12/1799 in the oracle table). :(

Strange thing is, there are many other records with the same dates, and they work fine - it only happens to particular records which have no unique traits when compared to other records that are being processed....

Once an offending record is found, the problem can be repeated ad infinitum - if the date is set to 1/1/1800, everything starts working - set it back to 31/12/1799 (even from Oracle) and the rollbacks return. :eek:

I am thinking that it must be some weird buffer overflow or PROIV/Oracle interface bug.... has anyone experienced something similar?