Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with xmltype column larger than 4000 bytes
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 BoyerReceived on Wed Jul 14 2004 - 10:37:15 CDT