Re: Long column

From: <rock_cogar_at_my-deja.com>
Date: Fri, 18 Aug 2000 18:19:49 GMT
Message-ID: <8njund$e72$1@nnrp1.deja.com>

Paolo,

I think that there is a package to do this task. It may be what is in ..\RDBMS\ADMIN\UTLRAW.SQL

Rock.

In article <8njq3u$k3r$1_at_fe1.cs.interbusiness.it>, "Paolo" <none_at_none.org> wrote:
> Hi all,
>
> How to update a LONG column with a string constant? Example:
>
> ( coly long )
>
> update tablex
> set coly = coly || '123456abcd'
> where colh = 1;
>
> I receive an error: ORA-00932: inconsistent datatypes
>
> Please help me
>
> Best regards Paolo
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 18 2000 - 13:19:49 CDT