Re: XML parsing using PL/SQL

We haven't done this in PLSQL before.
But we have tools that can generate language-specific XML parsers, and we could customize it to generate PLSQL. You could then run a PLSQL module to parse a collected XML document. A bit more customization, and it could extract just the fields you want.

I can send PowerPoint slides showing roughly how this is done, if you want.

Ira Baxter, Ph.D., CTO idbaxter_at_semdesigns.com 512-250-1018x140 Semantic Designs, Inc., www.semdesigns.com FAX 512-250-1191 12636 Research Blvd #C214, Austin, Texas 78759

"Neil Barton" <nbarton_at_dpapplications.com> wrote in message news:paoL5.2062$34.49303_at_e420r-sjo3.usenetserver.com...
> We have data that is stored in XML format in a series of rows that can be
> pieced together to represent the entire XML document, in a CLOB data type.
> We are not currently using the Context Option from Oracle. What we want to
> do is be able to parse the XML document looking for specific columns and
> values without requiring the Context options. Has anyone ever done this
> before in PL/SQL?
>
> TIA
>
>
>
>
>
>
Received on Fri Nov 03 2000 - 16:29:46 CET