Re: Appending data to a LONG field

It's easy enough in PL/SQL. Declare a variable as LONG and PL/SQL will append quite happily to standard CHAR functions. Then update accordingly.  The restriction on LONG types seems to be limited to SQLPLUS structure (possibly because it is directly impacting the database)

Steve Jakob <sjakob_at_octrf.on.ca> wrote in article <5el4rh$gkq_at_falcon.ccs.uwo.ca>...
> In article <330E3537.77C9_at_ehv.sc.philips.com>,
 S.mallory_at_ehv.sc.philips.com
> says...
> >
> >I have a table that has a LONG field that is used to store long bits of
> >text. I am wanting to append a bit of text onto the front of the text
> > <snip>
> >Shaun
> >smallory_at_ehv.sc.philips.com
>
> You cannot use a LONG variable in a SQL expression (in this case,
> concatenation). The Oracle 7 Server SQL Language Reference hints that the
 

> Oracle Call Interfaces might allow you to do this, but I'm unfamiliar
 with
> their use.
>
> --
> _________________________________________
> | Steve Jakob
> | Information Systems
> | London Regional Cancer Centre
> | sjakob_at_octrf.on.ca
> |_______________________________________|
>
>
Received on Fri Feb 21 1997 - 00:00:00 CET