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

[master_student]

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

[Anil_Babu_Samineni]

Have a look this..

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

ORA-00936: missing expression - TekStream

[andrespa]

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

[master_student]

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

Thanks

[Clever_Anjos]

Would you mind posting your entire sql?

Does this SQL runs using a SQL Client?