The other tool I use when I'm dealing just with XML is DBMS_XMLQuery. This package, along with DBMS_XMLSave, is for getting XML data out of the database if you want to later put it back in.
If you are using Java, you would probably want to use XSU and the Java API.
And finally, there is XML DB and WebDAV. If you have users wanting to access XML data directly, possibly even for updating it using MS-Windows tools like Excel, choose WebDAV.
I work primarily with 10g now and I would recommend you to upgrade if you can.
Dig Deeper on Oracle stored procedures
Related Q&A from Lewis Cunningham
I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to ... Continue Reading
How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this? Continue Reading
I have a table that I want to query by a char date field. I want to get the five most recent dates. So far using MAX in a subquery I can get one ... Continue Reading