Pass-Through Query Error

  • Thread starter Thread starter jutlaux
  • Start date Start date
J

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?
 
jutlaux said:
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?
Click to expand...

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