Re: Long column

From: bs135993 <didier.barjasse_at_skynet.be>
Date: Sat, 19 Aug 2000 23:24:51 +0200
Message-ID: <399EFB23.FD16C047@skynet.be>

Hi Paolo,

On an SQL statement you may not apply character fucntion but in PL/SQL Long variables are free of these restrictions.

I have tried this program and it works.

  1 declare
  2 test1 long;
  3 cursor c1 is
  4 select champ1 from test99;
  5 rec1 c1%rowtype;
  6 begin
  7 open c1;
  8 fetch c1 into rec1;
  9 test1 := rec1.champ1 || 'Test en plus grand '; 10 update test99
11 set champ1 = test1;
12 dbms_output.put_line( rec1.champ1 || ' '|| test1 ); 13 close c1;
14* end;

Didier

Paolo a écrit :

> 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
Received on Sat Aug 19 2000 - 16:24:51 CDT