Pass-Through Query Error

[jutlaux]

I am trying to setup a pass-through query with the below SQL

SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM
FROM FIN_CUR_CURE_CYCLE_SIDE_DATA;

When I run this as a select query I am prompted to log into the Microsoft
ODBC for Oracle connection and when I do the query returns the correct
results. When I set this up as a pass-through query and run it I get the
following error

ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid character (#911)

What am I doing wrong?

 

[Bob Barrows]

I am trying to setup a pass-through query with the below SQL

SELECT FIN_CUR_CURE_CYCLE_SIDE_DATA.MOLD_REV_NUM
FROM FIN_CUR_CURE_CYCLE_SIDE_DATA;

When I run this as a select query I am prompted to log into the
Microsoft ODBC for Oracle connection and when I do the query returns
the correct results. When I set this up as a pass-through query and
run it I get the following error

ODBC--call failed.
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00911: invalid
character (#911)

What am I doing wrong?

Unless it's the semicolon at the end, you will probably need to ask in an
Oracle group