Re: Oracle 8.0.5 and bitand()

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 11 Nov 1999 10:47:01 -0000
Message-ID: <942317299.27215.0.nnrp-12.9e984b29@news.demon.co.uk>

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

Jochen Lübbers wrote in message <382A7F24.AF16CDC5_at_tde-online.de>...

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 Received on Thu Nov 11 1999 - 04:47:01 CST