If you're working with XML and an Oracle Database, or
curious about trying, then you may be interested
in checking out some sample
PL/SQL-based XML utilities
and demos we've posted today at:
These utilties are all written in PL/SQL and work in any
or Oracle8 database.
You'll also find new postings for Oracle's XML Parser in Java
and an annotated version of Oracle's XML98 Keynote Address
slides explaining how the demos we did there worked.
Full source for the PL/SQL utilities and demos are included
the "PLSXML" suite below, downloadable from the site.
The "PLSXML" suite of PL/SQL-package-based
DBXML - For generating rich, nested XML
documents from SQL queries
DBDOM - For creating, parsing, traversing,
and searching XML
Documents using a subset of the Document Object
Model API using PL/SQL
DBXSL - For generating a database-driven XSL
stylesheet for a
tree-rendering of data (used by one of the demos)
along with a suite of XML/Oracle demos which I use to show them off:
1. Three-tier Web Page Validation Using XML/Oracle
Manipulation of Rich XML Query Results
3. Browser-based Search Results in
XML from the Database
4. Query and Tree Visualization of Oracle Data
5. "Realtime" stock quotes in XML, using XSL Stylesheets
Oracle Developer Form querying XML-based data from a URL
above leverage the latest XML/XSL features of IE 5.0 Beta2
XML/XSL delivered on-the-fly from the database.
These are PL/SQL
packages which I have found useful in my own
XML Evangelism inside and
outside the company and I hope can
help others learn about how much of a
natural fit XML and Oracle are.
Consulting PM & XML Technology Evangelist
Business Objects Development Team
Oracle XML Homepage http://www.oracle.com/xml