This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Jan 7, 2013 10:59 PM by 967681 RSS

RSS feed implementation in APEX

759084 Newbie
Currently Being Moderated
Hi all,

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.

Regards

Vivek
  • 1. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    This Tyler Muth’s Blog might help you
    http://tylermuth.wordpress.com/2008/01/22/producing-rss-from-plsql/

    Br,Jari
  • 2. Re: RSS feed implementation in APEX
    cc13 Newbie
    Currently Being Moderated
    Or you read this post:

    http://www.cc13.com/wordpress_21/2010/02/26/apex-rss-feed-aus-eigener-anwendung-bereitstellen/
  • 3. Re: RSS feed implementation in APEX
    759084 Newbie
    Currently Being Moderated
    Hi,

    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.

    Thank You
  • 4. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    You can create form for table where is RSS info.
    New lines are show in feed after you add new records to table.

    Then call procedure in page process "Before header" like
    htp.init;
    rss;
    Then go location
    http://you_rhost:port/pls/apex/f?p=app_id:page_id:0

    replace your_host, port, app_id and page_id accordingly.

    I think it is client side feature when it "refresh" feed information.

    Br,Jari

    Edited by: jarola on Mar 11, 2010 9:35 AM

    I did use Tylers guide and demo is here
    http://actionet.homelinux.net/htmldb/f?p=100:RSS:0
  • 5. Re: RSS feed implementation in APEX
    759084 Newbie
    Currently Being Moderated
    Thanks Jari,

    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.

    Any help will be appreciated.

    Regards

    Vivek
  • 6. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    Does my sample work ok whit those readers ?
    I can not now access my sample source code.
    I look it at evening and see if I did some other modifications.

    Try add at last to page process
    apex_application.g_unrecoverable_error := true;
    Br,Jari
  • 7. Re: RSS feed implementation in APEX
    759084 Newbie
    Currently Being Moderated
    Hi Jari,

    My sample code in apex.oracle.com works fine with google reader or microsoft outlook.

    But when i try to give the link of my actual project page(that outputs the xml code) to the google reader or microsoft outlook, these readers are no able to find the link itself.

    Will we have to do any changes on the server side? Or any changes in the procedure for RSS is required?

    Thanks for the help.

    Regards

    Vivek
  • 8. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    Is your HTTP server port open to internet so that Google can access your RSS fead URL?

    Br,Jari
  • 9. Re: RSS feed implementation in APEX
    759084 Newbie
    Currently Being Moderated
    Hi,

    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.

    So far it does not work with outlook also.
  • 10. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    Do you get any errors from Outlook when you try open that feed?

    Br,Jari
  • 11. Re: RSS feed implementation in APEX
    759084 Newbie
    Currently Being Moderated
    Ya,
    i get this error in outlook.

    "Outlook cannot process the RSS content from the link. The link may not point to a valid RSS source."

    In Google it says

    "Your search did not match any feeds."
  • 12. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    If you point your browser that URL you use in Outlook, can you see XML ?
    Do you have other pages in that application ?

    You did ask does this need some changes on server side.
    At least I did not do any, I just used Tylers guide with modifications that I did already post.

    Br,Jari
  • 13. Re: RSS feed implementation in APEX
    archana2 Newbie
    Currently Being Moderated
    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.

    Any suggestions ?

    Regards,
    Archana
  • 14. Re: RSS feed implementation in APEX
    jariola Guru
    Currently Being Moderated
    Hi,

    Is you page that shows RSS public?

    BTW, do not replay old post. Nobody get notified that there is new replays.
    Better create new post and add link to old one.

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points