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
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 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
I need a step-by-step procedure for importing text to an Oracle database using a stored procedure. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.