Oracle 8.0.5 and bitand()

Hi,

I've a little problem with the function "bitand" on Oracle 8.0.5:

On Version 7.3.2 I could use the build in function "bitand" without any problems on rows of the type "smallint".

But after migrating to Oracle 8.0.5 it does no langer work :( e.g.

    select bitand(gruppe,128) from [...];     ERROR:
    ORA-00932: inconsistent datatypes

I allways get this error message.
But why? And ecen more interessting, what can I do to get the correct result
128 or 0 (in the above example)??

Thanks for your help
J.L. =

• =

Jochen Lübbers                          luebbers_at_tele-data-electronic.d=
e
Software Development Group I            luebbers_at_tde-online.de
TDE - Tele Data Electronic GmbH              sw1_at_tde-online.de