Re: Oracle and Floating Points

dixon_at_tlh.fdt.net wrote:

> I have an Oracle 7.2 database with Delphi 2 front-end applications
> connected through SQL Links 3.5 and SQL*Net (version 2, I think). I need
> to do lookups on one table based on a primary key. Unfortunately, the
> primary key was defined as a NUMBER, which is not always precise (because
> it's a floating-point). The keys in the database are all stored
> correctly, but the key I'm searching for sometimes becomes imprecise. If
> I search for 123456789012, the Oracle engine will look for
> 123456789011.999. The person who built the database and apps has since
> left the company, and I now have to fix this problem. I know the proper
> solution would be to change the column to a VARCHAR2 (or maybe NUMBER(12)
> - I'm new to Oracle, but I understand that's an integer), but that
> requires more time than we have available. Does anyone know of a
> workaround or a later version that solves this problem (although it's not
> really a bug)? TIA Michael Dixon dixon_at_tlh.fdt.net

Oracle does actually have a FLOAT datatype, which may help.

Regards,

Ian Received on Fri Dec 05 1997 - 00:00:00 CST