NaN support in dbxOda

NaN support in dbxOda

Postby 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
If so, can you give a simple example of how to do this?
Posts: 15
Joined: Sat 02 Sep 2006 07:29
Location: Sweden

Re: NaN support in dbxOda

Postby 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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Return to dbExpress driver for Oracle