Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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:33:28 CDT