Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HELP: integer differences

HELP: integer differences

From: Geoffrey Callaghan <callagha_at_cs.fsu.edu>
Date: 1998/01/07
Message-ID: <690cql$hev$1@news.fsu.edu>#1/1

i've been passing integers into Oracle from a delphi 1.0 front end. On some client machines, the integers seem to be getting turned into floats when passed in. For example, 263 became 263.000000014. Since this is a key value, I am unable to get a match in a selection unless I round the number down in the stored procedure. Short of making all of my keys VARCHAR2's, what is a good way to ensure that no odd conversions occur? The field is a NUMBER(10,0).

		Geoff Callaghan
		callagha_at_cs.fsu.edu
Received on Wed Jan 07 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US