topic Direct Discovery Query Error -- ORA-00911 in QlikView

Direct Discovery Query Error -- ORA-00911

Sun, 27 Jul 2014 21:02:44 GMT

Hello Folks, I am creating Direct Table and I got the error while reloading.

OLEDB DB Connection;

DIRECT QUERY

DIMENSION

TECHID,

URM,

CLASSIFICATION,

READ_DATE

MEASURE

COUNTER

FROM DRRM_DM.M_CTR_INDIV

;

I got the below error:

Error: ErrorSource: OraOLEDB, ErrorMasg: ORA-00911: invalid character

Please help me why query got failed.

Re: Direct Discovery Query Error -- ORA-00911

Mon, 28 Jul 2014 15:30:12 GMT

Any thoughts?

Re: Direct Discovery Query Error -- ORA-00911

nishit_shah — Thu, 25 Feb 2016 15:21:46 GMT

Guys, Any Update on this ?

Re: Direct Discovery Query Error -- ORA-00911

petter — Thu, 25 Feb 2016 20:44:27 GMT

If you have the same question maybe it would be better to pose the question on a new thread and also include what kind of version of QlikView and Oracle ODBC drivers you are using. This is an old thread where we don't have much to go on...