Unable to use Decode on RAW columns ?

Can anyone explain what I am doing wrong below ?

What could be the workaround since I need to do the same in Pro*C for some large binary strings.

Thanks and please email me directly also.

-M

SQL> create table a_table (a_col long raw);

Table created.

SQL> insert into a_table values (hextoraw('20'));

1 row created.

SQL> update a_table set a_col = decode(1, 1, a_col, hextoraw('20')); update a_table set a_col = decode(1, 1, a_col, hextoraw('20'))

                                                                       *

ERROR at line 1:
ORA-00932: inconsistent datatypes

SQL> Received on Wed Jul 07 1999 - 21:32:26 CDT