This content has been marked as final. Show 5 replies
SQL_FLT supports logn double if compiled with 64 bit flags
The problem with SQLT_FLT is that the Oracle client fetches the value as NUMBER and then performs the conversion to the native double/long double type.
NUMBER is not supporting the full IIEE double range of values.
That why Oracle introduced in Oracle 10g the BINARY DOUBLE SQL type that can be fetched using SQLT_BDOUBLE / native host long variable. Thus the all range of C double and long double values can be used within OCI.
You need to use OCINumber to make your code platform resistent.
OCINumber DOES NOT support the double IEEE range of values !
Indeed. I completely missed the double part in the question - thought it was about long ints.