Re: how to update xml type from blob type?

From: takesiro <takesiro_at_coral.ocn.ne.jp>
Date: Sat, 13 May 2006 12:38:07 +0900
Message-ID: <e43kb2$8mr$1@news-est.ocn.ad.jp>

Hi!
Why don't you use CLOB?
XML convert to CLOB always.

You have to use BLOB. Would you try covert CLOB first with LOB locator.

Reagards.

"Aakash" <bordia_at_gmail.com> wrote in message news:1147471101.449063.158720_at_u72g2000cwu.googlegroups.com...
> Hi Guys, we have XML documents stored in BLOB column. And trying to
> convert them to XML data type. We need to do something like this:
>
> insert into o1(xmltype) select blob from o2;
>
> What conversion functions should we use?
>
> Thanks
>
Received on Fri May 12 2006 - 22:38:07 CDT