I'm trying to implement RSS (Really Simple Syndicate) feed in the APEX .
There's a page which shows data from the table in the database. The RSS feed has to reflect changes made to the database. Like if any data is added to the Database any RSS reader subscribed to the RSS feed should get updated with the content.
I'm not sure how to start with and there is little help available. Please help.
Thanks for the suggestions. I tried the steps given there and ultimately it displayed an output in the SQL workshop.
But I'm still not sure how an RSS reader will take the updates from there and how to integrate it with any apex application. Please help if possible.
It helped. But still i've to address many problems.
1. when i run the page containing the code (htp.init; rss;) ,sometimes it shows the output while at others there's a page with no content. But if i go the view page source of that blank page, it contains the xml code.
2. google reader was able to fetch the RSS feeds. while in microsoft outlook the feed was not updating.
The above was tried on an experimental basis in apex.oracle.com
3.When i tried to implement it for my actual project, the readers like Google reader or even the microsoft outlook was not able to find the page in which i was outputting the RSS feed.
This application is available only in the intranet and not available in the internet. It can't be searched by google. So just wondering whether we can access this in outlook or mozilla thunderbird when we are within the intranet.
I followed the same procedure explained above and it produces proper feeds in the live bookmarks in firefox. Also it loads the new feeds whenever a new record is created. But when i tried to add the feeds to the outlook reader it gives an error which says : Outlook can not process the RSS content from https://host/pls/apex/f?p=122:42
The link may not point to a valid RSS source.
Apex version : Application Express 4.1.0.00.32
Outlook : 2007
Application is in an intranet connection.