Lisa T wrote:
>
> Is it possible to use NVL or DECODE with a CLOB in Oracle 8i?
>
> For example,
> select nvl(clob_column,'None') from table;
>
> currently returns
>
> ERROR at line 1:
> ORA-00932: inconsistent datatypes
>
> Thanks. Lisa
This error is because the 2 arguments to the NVL() must be the same (a
clob is not a varchar2). How about NVL2() instead of NVL()? My guess
is this also holds for DECODE() as well.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Mon Nov 05 2001 - 16:30:59 CST
