1 2 Previous Next 15 Replies Latest reply: Jan 8, 2013 12:59 AM by User12961470-Oracle RSS

    RSS feed implementation in APEX

    759084
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            Hi,

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

                            Br,Jari
                            • 11. Re: RSS feed implementation in APEX
                              759084
                              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
                                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-Oracle
                                  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
                                    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