ORA-01489 result of string concatenation is too long

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Wed, 16 May 2001 13:25:41 -0700
Message-ID: <F001.003055FB.20010516132043@fatcity.com>

Hi!

I'm concatenating two LONG columns (2800 characters each). I get an

ORA-01489 result of string concatenation is too long Cause: String concatenation result is more than the maximum size. Action: Make sure that the result is less than the maximum size.

Although the variables used are set as LONG, it seems that still the 4000 character limit (e.g. for varchar2) kicks in.

Any iedas anybody?

This is 8.1.6. on Win2k.

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Helmut Daiminger
INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 16 2001 - 15:25:41 CDT