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
Posts: 15
Joined: Sat 02 Sep 2006 07:29
Location: Sweden

NaN support in dbxOda

Post by LeifS » Wed 23 May 2012 13:49

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 ... tm#i139891
If so, can you give a simple example of how to do this?

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


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