Business Objects - Oracle binary double data type

[Former Member]

Hello,

I would like use Business Objects (XI 3.1 SP2) with scientist data and an Oracle 11G database. For a better accuracy on floating data, I use Oracle binary double datatype, but this datatype is not supported by Business Objects. WebI and Designer throw an exception (Exception : CS, Non supported datatype).

Does anyone has encountered this kind of problem, and if so found a solution?

Best regards.

[Former Member · Accepted solution]

Hi Nicolas,

I've not used DOUBLEs for reporting but I know there are ways of converting them to NUMBER.

The UTL_RAW package could be used in a query to create a derived table and you could then pull data from that?

Have a look here for more info on UTL_RAW

http://psoug.org/reference/utl_raw.html

Regards

Gary