pelekhl

Hello,

I have a silly situation that I can't figure out. I have the following
query:

select *
from table1 join table2@mssql on table1.field1 = table2.field2
where BITAND(table2.bitfield, 256) = 0

Table2 is is in a linked database, residing on Microsoft SQL server.
Trouble is Oracle insits on executing BITAND on MSSQL, as it
rightfully wants to filter the resultset before transfering it over.
MSSQL does not support BITAND (it has an & operator), so I get an
error:

ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][A096] Unknown function BITAND() with
2
operands
ORA-02063: preceding 2 lines from LINK1

Any ideas? Thanks so much in advance.

lev.