Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Hi All,

I am fetching data from one table in oracle using oledb connection into QlikView and getting the following error :

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Earlier I was using odbc connection, and it was all working fine.

While analyzing the issue, I found that the issue is occurring due to one field which is having datatype as "Number" in oracle.

Does any one have idea how to resolve this?

Thanks in advance!

Regards,

Nawaz

0 Replies