NaN support in dbxOda

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
LeifS
Posts: 15
Joined: Sat 02 Sep 2006 07:29
Location: Sweden

NaN support in dbxOda

Post by LeifS » Wed 23 May 2012 13:49

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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: NaN support in dbxOda

Post by AlexP » Thu 24 May 2012 08:18

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

Post Reply