Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01489: result of string concatenation is too long
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
Received on Tue Oct 05 1999 - 05:37:26 CDT