Re: updating clob datatype

Manikandan wrote:

> Hi,
>
> Pls look into the following:
>
> TRN: att Mani>desc event_log;
>
> Name Null? Type
>
> ------------------------------- -------- ----
>
> DESCRIPTION CLOB
>
> TRN: att Mani>select * from event_log;
>
> DESCRIPTION
>
> ----------------------------------------------------------------------
> ----------
>
> e_INTL table,TCF_KEY have been populated
>
> 1 row selected.
>
> TRN: att Mani>update event_log set description = description||'mani';
>
> update event_log set description = description||'mani'
>
> *
>
> ERROR at line 1:
>
> ORA-00932: inconsistent datatypes
>
> TRN: att Mani>
>
> PLease guide me how to resolve this issue?
>
> --
> Posted via http://dbforums.com

CAST or TO_CLOB

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)