I want to write a MySql procedure which returns a formatted XML file i.e. 'OUT BLOB'.

Has anyone come across such a procedure or is it better to make a Java etc... code do the same?

Recommended Answers

All 4 Replies

I've done this for an RSS feed. It queries the db, populates variables, and outputs everything as xml. Here is the link.

I wanted to know if it is posiible to write a MySql procedure to do the same??? Is that possible

Yep thanks again for the above information, what i wanted to know was if i could get a MySql stored procedure to do the same!!!! This way i can customize the procedure to give me some data based on the data in the database, rather than giving me all the data as an XML snap shot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.