Re: Unable to use Decode on RAW columns ?

From: Michael Ho <infoage_at_hk.super.net>
Date: Sun, 11 Jul 1999 02:51:23 +0800
Message-ID: <3787962B.A5717593@hk.super.net>

DECODE do work on RAW, but you can't update a LONG RAW field like that. Replacing LONG RAW with RAW(??) will work.

As I know for LONG RAW, you must bind a variable, with select, update or insert, using Pro*C or OCI.

Oracle suggestion, don't use LONG RAW, use BLOB or CLOB instead.

I am also looking for better solution to this, for some reason, I can't use LOB yet. If you get it, could you please forward it to me.

Mirza Mohsin Beg wrote:

> 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.
>
>
Received on Sat Jul 10 1999 - 13:51:23 CDT