Direct Discovery Query Error -- ORA-00911

[#1]

Hi All,

I'm doing nothing more than pulling straight table from oracle through direct discovery but it is resulting in error.

SQL##f - SqlState: S1000, ErrorCode: 911, ErrorMsg: [Oracle][ODBC][Ora]ORA-00911: invalid character

CMNT:

DIRECT QUERY

DIMENSION

VAL1 AS FLAG,

VAL2

FROM SCHEMA1.TABLE1

Please suggest me!

Thanks,

Vinod Kumar V

[Clever_Anjos]

Oracle/PLSQL: ORA-00911

[Clever_Anjos]

It would be easir if you post your actual query

[#4]

$(Include=..\oracleconnection.txt);

CMNT:

DIRECT QUERY

DIMENSION

VAL1 AS FLAG,

VAL2 AS COMNT,

USERNAME,

VALUE AS TRANSACTION_NAME

FROM PWI_PROFILER.BWISEDOSPOC2_SELECTION, PWI_PROFILER.BWISEDOSPOC2_DE

WHERE PWI_PROFILER.BWISEDOSPOC2_SELECTION.DE_ID = PWI_PROFILER.BWISEDOSPOC2_DE.ID AND PWI_PROFILER.BWISEDOSPOC2_DE.USERNAME<>'test';

This is my query. query is working absolutely fine when i try to run it from my desktop but it is failing in server.