Bug 47879

GemConnect

2.3, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.1, 2.1, 2.0.1, 2.0

All Platforms

2.4

BINARY_FLOAT / BINARY_DOUBLE not supported

There is no support for Oracle data types BINARY_FLOAT and BINARY_DOUBLE.  Attempts to read fields with these data types will return nil.

Workaround

For reading, you can use the SQL"cast" function to cast the field as a float.

For example, if MyTable contains binary_float field BF and binary_double field BD, you can use the following statement in the openCursor:* call:

select cast(BF as float), cast(BD as float) from MyTable


Last updated: 1/22/19