Issue Exporting to CSV When Using Double or Float in Calculations – OAC/OAS

Question

Are there any limitations in OAC/OAS that prevent data export to CSV when calculations involve Double or Float data types?

Steve F-2 · Answer

Hi,

More clarifying details are always helpful.

* What is the "issue"?  The export never completes? There is an error? It completes, but something is missing?
* You mention OAC/OAS, if OAS which yearly update are you using and the patch level.
* Which part of the product are you exporting with? Classic? Workbook visualization? - Steps/examples
* May we assume it works correctly when the calculation is removed?
* Example of the calculation

Since these are binary types, there are some general limitations documented

For information about DOUBLE and FLOAT, see Floating Point Limitations and Data Type Limitations.

To avoid the limitations of the FLOAT and DOUBLE types, Oracle suggests that you update the FLOAT and DOUBLE data types to the NUMERIC type. There is no workaround to fix the inherent limitations with binary floating point data types, other than switching to the NUMERIC data type.

Benjamin Arnulf-Oracle · Answer

@Alan Lee - Oracle-Oracle would you know?