Re: ORA-01489: result of string concatenation is too long

From: <karsten_schmidt8891_at_my-deja.com>
Date: Wed, 06 Oct 1999 14:26:05 GMT
Message-ID: <7tfm5d$r1r$1@nnrp1.deja.com>

Chris,
you might be hitting the sql limit of 4000 bytes (2000 in oracle 7) rather than pl/sql limits.

i suppose, oracle tries to convert the long values to varchar2, and gets into trouble. check your bind / define variables for that.

posting some code-snippets might give a clue. (maybe without your 7k strings..)

Karsten

> > 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
> > >
>
> --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 06 1999 - 09:26:05 CDT