RE: ORA-01489 -- error

From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) <DBA.Gurgaon_at_geind.GE.com>
Date: Thu, 13 Jul 2000 10:21:13 +0530
Message-Id: <10556.111919@fatcity.com>

ORA-01489: result of string concatenation is too long

The result of a string concatenation was larger than the maximum length of a string (2000 characters).

Reduce the size of one or both of the strings to be concatenated. Make certain the total length of the concatenation result is less than 2000 characters.

Vikas

-----Original Message-----
From: Mani Sivakumar [mailto:m.sivakumar_at_CSDCSYSTEMS.COM] Sent: Wednesday, July 12, 2000 10:39 PM
To: Multiple recipients of list ORACLE-L Subject: ORA-01489 -- error

I am getting the following error when importing a data from a table to a CSV file.
ORA-01489: result of string concatenation is too long. I am not sure how to fix it. Any idea?
Thanks!
M.SIVAKUMAR

-- 
Author: Mani Sivakumar
  INET: m.sivakumar_at_CSDCSYSTEMS.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 Jul 12 2000 - 23:51:13 CDT