I'm developing a C++ library with oracle OCI library. I'm loading from a Oracle Database 11g database. Here I need to load large values with decimal places. In this case I need to use long double instead of double. I'm not sure whether OCI supports for long double.
According to the documentation SQLT_FLT is for float and double only. Can someone let me know whether OCI supports for long double and if so how to retrieve them
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.