Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

use 'OLEDB CONNECT 64bit oracle happen 1 change 1.00000000000000000000000000000000000

When I user ''OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;User ID=fbi_dw;Data Source=mic133] (XPassword is DORLQTRMITccWcBHBDZOXGC);'' to connect oracle .I reload again ,my date has someting error. how to solve it 未命名.JPG

24 Replies
ashfaq_haseeb
Champion III
Champion III

Hi

While loading data from oracle database, try to use date conversion functions.

Hope that helps

Regards

ASHFAQ

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Something like this:

MyTable:
LOAD Num(MYVALUE) AS MYVALUE

....;

SQL SELECT MYVALUE

FROM MYTABLE;

Wrapping numerical values with NUM will remove the trailiing zeroes which are causing the problem.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rbecher
MVP
MVP

I presume you're selecting from an Oracle view?

Just use Number format Integer.

- Ralf

Astrato.io Head of R&D
Not applicable
Author

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908

Not applicable
Author

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908wsw19870908

Not applicable
Author

HI

  Please give me some example,,thank you very much!

Regards

wsw19870908wsw19870908

rbecher
MVP
MVP

Can you upload an example app or the SELECT statement?

- Ralf

Astrato.io Head of R&D
Not applicable
Author

@TIQView - Ralf Becher 编写:

Can you upload an example app or the SELECT statement?

- Ralf

This is an example

rbecher
MVP
MVP

Do you know if "FBI_DW"."DIM_CALENDAR" is a table or view?

In the Oracle ODBC setting (haven no OLEDB yet) is an option Bind Number as Float, is this checked?

oracle_odbc.png

In the meantime you can adjust number formats in the QlikView document settings:

integer.png

added second picture

Astrato.io Head of R&D