Skip to Content.
Sympa Menu

xom-interest - Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery

xom-interest AT

Subject: XOM API for Processing XML with Java

List archive

Chronological Thread  
  • From: Anoop kumar V <anoopkumarv AT>
  • To: Elliotte Harold <elharo AT>, xom-interest AT
  • Subject: Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery
  • Date: Tue, 27 Dec 2005 11:21:41 -0500

Yes - as far as what I have read - Oracle 9i and moreso 10g has XML
support. There is also a datatype called XMLType on which you have an array
of functions.

If you are dealing with data that is not XMLType, then you should atleast
have it (or convert it to) a CLOB and then you can exploit more or less the
same functions..

In my case, unfortunately however, the XML document data is stored in a
column of type LONG - and Oracle has little to no functions to work on LONG
- hence I need to read / stream this data and use an external tool (like
NUX, Saxon) to parse this data using Xquery...

Hope that helps,

On 12/27/05, Elliotte Harold <elharo AT> wrote:
> Wolfgang Hoschek wrote:
> > I'm not sure how you might have got the impression that Nux is, or
> > connects to, a database system.
> > Sorry, but that's not what it's designed for. Rather it's designed to
> > operate on streams or main memory trees.
> >
> Just surmising here: Does Oracle maybe have some sort of mode in which
> it exposes its tables or records as XML documents, or some such?
> --
> Elliotte Rusty Harold elharo AT
> XML in a Nutshell 3rd Edition Just Published!

Thanks and best regards,

Archive powered by MHonArc 2.6.24.

Top of Page