Xref: alice comp.databases.oracle.server:73493
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle 8.0.5 and bitand()
Date: Thu, 11 Nov 1999 10:47:01 -0000
Message-ID: <942317299.27215.0.nnrp-12.9e984b29@news.demon.co.uk>
References: <382A7F24.AF16CDC5@tde-online.de>
X-Trace: news.demon.co.uk 942317299 nnrp-12:27215 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 31

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@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