chris, try set long 100000. ted
In article <37F9D4E6.16BFE772_at_nortelnetworks.com>,
Chris Forlano <cforlano_at_nortelnetworks.com> wrote:
> I'm using SQLPlus (Oracle 8.0.5 on HPUX-10.20).
> I am updating the value of a LONG to a value of about 7K and I receive
> the following message:
>
> ORA-01489: result of string concatenation is too long
>
> I was my understanding that PSQL could handle a value for a long of up
> to 32K.
> So what's going on? Do I need to break my concatenation into chunks
of
> 2K?
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> Automation Development
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Oct 05 1999 - 08:08:52 CDT
