Re: help with xmltype column larger than 4000 bytes

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 13 Jul 2004 17:05:42 -0700
Message-ID: <1089763560.90028@yasure>

roger wrote:

> Help please...
>
> I'm on 9.2.0.3.0, on solaris.
>
> I've got a table with a sys.xmltype colum,
> on which I need to do a string replace function like so:
>
> update table mytable
> set myxmlcol = replace(myxmlcol, oldval, newval)
> where ...
>
> The problem is that if the myxmlcol contains more
> than 4000 characters, this fails with an oracle error:
>
> ORA-19011: Character string buffer too small
>
>
> I have no problem creating and reading back the column
> using sys.xmltype.createxml and sys.xmltype.getstringval.
>
> Is there some parameter that I can set to increase
> the size of whatever internal buffer is causing me this problem.
> 8000 would suffice in my case.
>
> Thanks.

You don't have more than 4000 bytes in a VARCHAR column. Likely it is a CLOB and you need to use the dbms_lob built-in package.

Daniel Morgan Received on Tue Jul 13 2004 - 19:05:42 CDT