Page 1 of 1

NaN support in dbxOda

Posted: Wed 23 May 2012 13:49
by LeifS
Hi,
does your dbExpress driver for Oracle support writing NaN (Not a Number) to a field of type BINARY_DOUBLE?
(E.g. using the literal binary_double_nan as in http://docs.oracle.com/cd/B13789_01/ser ... tm#i139891
If so, can you give a simple example of how to do this?

Re: NaN support in dbxOda

Posted: Thu 24 May 2012 08:18
by AlexP
hello,

NaN (Not a Number) - an Oracle internal notion, and there are no analogous types in Delphi, therefore using dbExpress you can insert such data only in "clean" SQL - without using parameters