xom-interest AT lists.ibiblio.org
Subject: XOM API for Processing XML with Java
List archive
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery
- From: Anoop kumar V <anoopkumarv AT gmail.com>
- To: Elliotte Harold <elharo AT metalab.unc.edu>, xom-interest AT lists.ibiblio.org
- 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,
Anoop
On 12/27/05, Elliotte Harold <elharo AT metalab.unc.edu> 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 metalab.unc.edu
> XML in a Nutshell 3rd Edition Just Published!
> http://www.cafeconleche.org/books/xian3/
> http://www.amazon.com/exec/obidos/ISBN=0596007647/cafeaulaitA/ref=nosim
>
--
Thanks and best regards,
Anoop
-
[XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Anoop kumar V, 12/26/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Wolfgang Hoschek, 12/26/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Elliotte Harold, 12/27/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Anoop kumar V, 12/27/2005
- Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery, Wolfgang Hoschek, 12/27/2005
- Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery, Wolfgang Hoschek, 12/27/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Anoop kumar V, 12/27/2005
- Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery, Anoop kumar V, 12/27/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Elliotte Harold, 12/27/2005
-
Re: [XOM-interest] Nux | Oracle database connections to use collection() in XQuery,
Wolfgang Hoschek, 12/26/2005
Archive powered by MHonArc 2.6.24.