
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a look this..
http://stackoverflow.com/questions/12156399/how-to-resolve-ora-00936-missing-expression-error
ORA-00936: missing expression - TekStream


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andres, I am not hidding anything in my query except this clause 'and debited_actor_id IN ()' that contains a variable.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you mind posting your entire sql?
Does this SQL runs using a SQL Client?
