Re: help with xmltype column larger than 4000 bytes

roger wrote:
> OK...
> So I take it that what is happening is that when I try
> to use the replace function, Oracle converts the xmltype
> col to varchar(4000) internally and that's where the problem
> arises?
>
> So, there is no initialization parameter to increase the
> max size of a varchar column then I take it?
> If I could just raise that limit to 8000, I'd be set...
>
>
> Otherwise, can you (or someone) please give me an indication
> of if it is even possible, and if so how, to use the
> dbms_lob package to accomplish what I'm trying to do,
> which is essentially, to replace all ocurrances of some
> string with some other string in an xmltype (or clob I guess)
> column that is larger than 4k.
>
> Thanks a bunch.

VARCHAR2 columns max at 4K bytes. VARCHAR2 variables at 32K.

XML should be stored as a CLOB or using the internal XML data type.

Daniel Morgan Received on Wed Jul 14 2004 - 00:10:03 CDT