| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: bitand() no longer seems to work in Oracle8
A copy of this was sent to bweinra_at_uswest.com
(if that email address didn't require changing)
On Fri, 12 Mar 1999 01:23:29 GMT, you wrote:
>In oracle 7 you could fun things like
>
yes, it is sqlplus being pickier, not a change in bitand(). workaround is:
1* select bitand(12,9)+0 from dual
SQL> /
BITAND(12,9)+0
8
or:
SQL> select to_number(bitand(12,9)) from dual;
TO_NUMBER(BITAND(12,9))
8
plus is seeing 'binary_integer' and thinking 'raw'.
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |