bitand() no longer seems to work in Oracle8

From: <bweinra_at_uswest.com>
Date: Fri, 12 Mar 1999 01:23:29 GMT
Message-ID: <7c9qa8$576$1@nnrp1.dejanews.com>

In oracle 7 you could fun things like

select bitand(12,9) from dual;

b
-

8

In oracle 8 you get:

ERROR:
ORA-00932: inconsistent datatypes

The def from the rdbms/admin/standard.sql file seems to be the same:

function BITAND (LEFT binary_integer, RIGHT binary_integer)

return binary_integer;

Yeah ..... life sucks. Anyone here know if this is just plain FUBAR in Ora8 or whether you have to be smarter than the function :)

-bret

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 19:23:29 CST