Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
onion77
Contributor
Contributor
‎2022-06-01 06:27 AM

Error [HY000] [Qlik][OracleOCI] (300) Oracle Caller Interface: ORA-00942 after an upgrade

Hi, we started to get an error Error [HY000] [Qlik][OracleOCI] (300) Oracle Caller Interface: ORA-00942 after an upgrade from Qlik April 2021 to May 2022 patch1. This connection worked fine in the past, the tables exists. We managed to find out that the problem is actually having  NCLOB data type columns in the DB tables. When we tried to newly re-connect to the DB , the error changed to ORA-00903

When we change the data type to varchar, it all works fine.

Is there any way how to make it work without actually changing to the varchar data type, please?

Labels (1)
Labels
335 Views
0 Likes
1 Reply
Vikram_Jayakumar
Support
Support
‎2022-06-12 06:34 PM

Hi, @onion77 looks like something has already been reported as a defect QB-10789. Check your ODBC Package version 

If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
284 Views
0 Likes