topic Re: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente in QlikView

ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

master_student — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone, I get this error message :ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

Here 's my query:

select tt.*, d.aliasname cl2

from (

SELECT

REPORT_TYPE,

REPORT_DATE,

DEBITED_ACTOR_ID,

CREDIT_ACTOR_ID,

credit,

tab.ALIASNAME cl1

FROM POS_REPORT_FINAL_1904 trans , DUMP_RETAILER_FINAL tab

WHERE

trans.debited_ACTOR_ID =tab.ACTORE_ID(+)

and report_type = 'TSR001'

AND function_id = 243

and debited_actor_id IN ()

AND OPER_STATE = 61

AND IERRORX = 0) tt, DUMP_RETAILER_FINAL d

where

tt.credit_ACTOR_ID =d.ACTORE_ID(+)

Could you assist me please

Re: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

Anil_Babu_Samineni — Wed, 01 Jun 2016 09:00:26 GMT

Have a look this..

http://stackoverflow.com/questions/12156399/how-to-resolve-ora-00936-missing-expression-error

ORA-00936: missing expression - TekStream

Re: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

andrespa — Wed, 01 Jun 2016 09:09:57 GMT

Hi, you ommited some part of your query, but at first glance I couldn't find any error, just maybe the semicolon at the end. But for sure it's a query incomplete problem.

Hope it helps,

Andrés

Re: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

master_student — Wed, 01 Jun 2016 13:03:49 GMT

Hi Andres, I am not hidding anything in my query except this clause 'and debited_actor_id IN ()' that contains a variable.

Thanks

Re: ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

Clever_Anjos — Wed, 01 Jun 2016 13:29:37 GMT

Would you mind posting your entire sql?

Does this SQL runs using a SQL Client?