Re: Oracle 8.0.5 and bitand()

Jonathan Lewis wrote:
> =

> bitand() returns the pl/sql type BINARY_INTEGER,
> and it seems that this in no longer coerced automatically
> by SQL - the solution seems to be simply:
> =

> select to_number(bitand(x,y)) from . . .
> =

> --
> =

> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> =

Thanks for your fast reply, it works
But I'm still a little unhappy because that means that I've to change all sources from "bitand()" to "to_number(bitand())" and they are no langer protable between BD" and Oracle as the should be.

So are there any other ways to get the same result, but without the need to change the functioncall??

Thanks again.
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