Re: help with xmltype column larger than 4000 bytes

From: roger <xrsr_at_rogerware.com>
Date: Wed, 14 Jul 2004 22:00:01 GMT
Message-ID: <Xns9526990EB597rsrrogerwarecom@204.127.204.17>

I've implemented what I need to do using the dbms_lob functions. Thanks for the suggestion.

Galen Boyer <galenboyer_at_hotpop.com> wrote in news:usmbuhadk.fsf_at_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
Received on Wed Jul 14 2004 - 17:00:01 CDT