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

Karsten,

Sounds like you hit the nail right on the head. I was not aware of the 4K sql limit.
In my testing I have been noticing that is the threashold.

I'm trying something like the following:

    update test set ts_description = '<over 4K of multiline text>' where ts_test_id = 1234;

I'm wondering if there is a way to break up, say a 12K value, into three chunks of 4K.
For a varchar2, I'd use concat(), but, of course, this is not supported for LONGs.
I also do not have the option of using a CLOB, as many people will recommend.

Any assistance you can give would be most appreciated.

Thanks,

Chris

karsten_schmidt8891_at_my-deja.com wrote:

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

--
Chris Forlano
Automation Development
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Wed Oct 06 1999 - 12:20:16 CDT