Re: help with xmltype column larger than 4000 bytes

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 14 Jul 2004 10:37:15 -0500
Message-ID: <usmbuhadk.fsf@standardandpoors.com>

On Wed, 14 Jul 2004, xrsr_at_rogerware.com 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?

I believe you have to roll your own "replace".

The XMLType can return a clob. The CLOB has functions, INSTR() to get at the offsets you want to replace and WRITE() to write characters to offsets.

Thats what I'd play with as my second choice. My first choice would be to check out asktom and see if he has examples.

http://asktom.oracle.com/pls/ask

-- 
Galen Boyer

Received on Wed Jul 14 2004 - 10:37:15 CDT