20th April 23:23
Question: BITAND Oracle function and ODBC database link
I have a silly situation that I can't figure out. I have the following
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
ORA-28500: connection from ORACLE to a non-Oracle system returned this
[Generic Connectivity Using ODBC][A096] Unknown function BITAND() with
ORA-02063: preceding 2 lines from LINK1
Any ideas? Thanks so much in advance.