Q
Problem solve Get help with specific problems with your technologies, process and projects.

Generating XML from stored procedures

What are the best ways to generate XML from stored procedures? I have tried using SQLX with version 9i and it works pretty nice. I would like to know if you can recommend any other ways of doing it and suggest which approach has to be taken in what situations.

What are the best ways to generate XML from stored procedures? I have tried using SQLX with version 9i and it works pretty nice. I would like to know if you can recommend any other ways of doing it and suggest which approach has to be taken in what situations.
I love SQLX. You would use SQLX when you need to tightly integrate SQL commands and XML fragments.

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.

This was last published in July 2005

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close