topic Re: Loading using Oracle OLEDB-Error reading number format in QlikView

Loading using Oracle OLEDB-Error reading number format

Wed, 09 Nov 2011 18:50:12 GMT

Hi,

When I try to load the data using Oracle provider for OLEDB conection, it reads all the numbers as integers and appends .000000000000......... for all the number columns. If I load same with Mircosoft OLEDB provider for Oracle it is reading numbers correctly. The data type is always a number. Other than using Num function when loading is there a solution with using Oracle provider for OLEDB? Not sure why it is reading numbers as integers. Any help is appreciated.

Thanks in advance.

Re: Loading using Oracle OLEDB-Error reading number format

stevedark — Mon, 01 Oct 2012 14:26:17 GMT

Just put a Floor statement around any numbers you pull out to remove the decimal zeros eg.

Floor(ORACLE_VALUE) as [Oracle Value],

If you want to keep some of the decimal information, but not to that many decimal places do the same but with the Round function:

Round(ORACLE_VALUE, 0.0001) as [Oracle Value],

This is just a bit of a quirk with the driver, but is easy to work around.

- Steve