https://community.qlik.com/t5/Connectivity-Data-Prep/ERROR-HY000-Qlik-OracleOCI-3000-Oracle-Caller-Interface-ORA/m-p/2141528#M13068 <P>Qlik doesn't execute any SQL else just transferred the query per driver to the data-base and get on this way back the results. If the query worked within the data-base but not by calling it per external driver it makes it very likely that the driver couldn't handle anything properly (unsuitable configuration, wrong driver, too old, ..).</P> <P>Therefore take a look for another one and/or create (for a testing purpose) a view from the query and query then this view (it will exclude any causes in regard to resolve the query and limit the causes to data-quality or data-type stuff). Also a look within the data-base log may give some valuable hints.</P> Mon, 27 Nov 2023 11:33:23 GMT marcus_sommer 2023-11-27T11:33:23Z https://community.qlik.com/t5/Connectivity-Data-Prep/ERROR-HY000-Qlik-OracleOCI-3000-Oracle-Caller-Interface-ORA/m-p/2141402#M13064 <P>Qliksense keeps throwing me this error.... ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00936: missing expression.&nbsp;<BR />I've used SQL Developer to test the query but don't see any issue with the query. Any idea how I'd go about resolving this?<BR />I've tried breaking the query down to something more similar but also getting the same issue as well.<BR />Thinking if i should consider doing CTE to help resolve this or would it still be the same.</P> <P>&nbsp;</P> Mon, 27 Nov 2023 06:28:47 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/ERROR-HY000-Qlik-OracleOCI-3000-Oracle-Caller-Interface-ORA/m-p/2141402#M13064 Keitaru 2023-11-27T06:28:47Z https://community.qlik.com/t5/Connectivity-Data-Prep/ERROR-HY000-Qlik-OracleOCI-3000-Oracle-Caller-Interface-ORA/m-p/2141528#M13068 <P>Qlik doesn't execute any SQL else just transferred the query per driver to the data-base and get on this way back the results. If the query worked within the data-base but not by calling it per external driver it makes it very likely that the driver couldn't handle anything properly (unsuitable configuration, wrong driver, too old, ..).</P> <P>Therefore take a look for another one and/or create (for a testing purpose) a view from the query and query then this view (it will exclude any causes in regard to resolve the query and limit the causes to data-quality or data-type stuff). Also a look within the data-base log may give some valuable hints.</P> Mon, 27 Nov 2023 11:33:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/ERROR-HY000-Qlik-OracleOCI-3000-Oracle-Caller-Interface-ORA/m-p/2141528#M13068 marcus_sommer 2023-11-27T11:33:23Z