| How-To Document
Integrating Yahoo Pipes into an Oracle Application Express Application
After completing this How-To, you will:
Table of Contents
But how to integrate the output of such a Yahoo Pipe into your Oracle APEX Application?
This document describes how to leverage the power of the built-in features of the Oracle Database to include the Pipe output as a report into an Oracle APEX Application.Software Requirements
Logon to Yahoo Pipes and create your own pipe. For this How-To I have created a Pipe which:
Figure 1: Yahoo Pipe to translate an RSS feedRun your Yahoo Pipe
Run your pipe (you don't have to publish it) and look for "Tools: Get as RSS" at the bottom of the page. Get the URL, e.g. it looks like
http://pipes.yahoo.com/pipes/0HpUBCq52xGdaeRPfOgC8A/run?_render=rssCreate a report in Oracle APEX
Create a SQL based report (Create Region\Report\SQL Report) with the following SQL statement:
Replace the URL with your stored URL. The output of the URL is an RSS feed with a defined XML format. You can see the format when you paste the URL into your browser and use the "View Page Source" to view the XML output.About the SQL Statement
The Oracle built-in package HTTPURITYPE is really powerful! It will retrieve the content of an URL and if you specify getXML, automatically convert the XML output into an Oracle XMLTYPE. As soon as it is a XMLTYPE you can use all the Oracle XML built-ins to extract the data from the XML stream. For more information about HTTPURITYPE or the XML built-ins, see
Run the report
Run your Oracle APEX page and you should get a similar output.
Figure 2: Oracle APEX Report showing Yahoo Pipe outputConclusion
As you can see from the above description, integrating Web-/XML content into your Oracle APEX Application can be quite simple if you combine the power of Oracle APEX and the underlying Oracle Database.
Feel free to discuss this How-To in the Oracle APEX OTN Discussion Forum.About the Author:
Patrick Wolf is working at Sphinx IT Consulting as a Senior Solution Architect and is an Oracle specialist (PL/SQL, Oracle APEX, Oracle Developer) who likes to share his Oracle APEX expertise. He is running an Oracle APEX blog and is the creator of the Open Source Oracle APEX development framework ApexLib and the Oracle APEX Builder Plugin. He can be contacted at firstname.lastname@example.org