I’m currently working on a project for Denali Flavors Ice Cream. This involves creating a website where customers can locate stores which carry their brand of ice cream. I’ve already created a well-formed normalized Oracle database as well as XSQL and XSLT pages that allow users to input data and generate reports based on views. Right now I’m also trying to implement the reports in RSS. I need to generate a valid feed, not just a well-formed document. My plan is to create a feed that notifies customers of store additions to the database. Any help or suggestions would be appreciated.

Here is the sample page for this project (Note that the store lookup query is not yet functioning):
http://emegaweb.net/denali/

Just a off topic question, but is there a reason you are using Oracle? Seems like overkill for this application.

What language are you using for the site? Feeds can be generated in any language that can output XML files.

The web site and Oracle database were part of a final project for a database course I was taking. We used Oracle since it is by far the most widely used server database.
For the RSS, I ended up writing an XSQL file to pull the information directly from the database. Then I wrote an XSLT template to transform the result into an XML file. The feed is located at the following URL: http://elab-linux4.bus.umich.edu:8080/%7Ekevlers/RSS/testRSS.xsql (http://elab-linux4.bus.umich.edu:8080/~kevlers/RSS/testRSS.xsql)
If anyone else is trying to create an RSS feed, I would recommend looking at this web site (http://lundie.ca/permalink/30f187a1df624f7ab6723817563b9d9e).