United StatesChange Country, Oracle Worldwide Web Sites Communities I am a... I want to...
Return to Oracle APEX Home

Oracle Application Express

Web Services Integration


 

Application Development today often involves integrating services from other companies, vendors, and other third parties. Application Express easily integrates with these services through either built-in Web service support or through lower level PL/SQL UTL_HTTP package calls. Below are white papers and sample applications all about using these integration techniques in Application Express.

Oracle Application Express 4.0 offers a number of improved and new Web services features including support for RESTful style Web services both from the consumer and provider perspective. The Application Express 4.0 Web Services Evaluation Guide explains these new Web service features together with step by step instructions.

Below is a list of services that we have examples for:

Please note, these application can only be imported into Oracle Application Express 3.0 or higher and cannot be run on apex.oracle.com because it does not support external network call-outs.  You can import and install the application but data will not display if you run it.

 

Amazon S3

This white paper and corresponding sample application showcases Oracle Application Express 4.0 support of consuming RESTful style web services using the Amazon Simple Storage Service (Amazon S3). Amazon S3 provides highly available and highly scalable Internet storage. The paper describes step by step how to build an Amazon S3 client with Oracle Application Express 4.0.

Links:  White Paper
Download:  amazon_s3.zip

 

Oracle BI Publisher

This demonstration application shows how Application Express can be used to call BiPublisher's PublicReportService Web service using PL/SQL.

You login to the application using a BiPublisher user, browse folders and reports that the user has access to, and you can click on the reports and download directly from this application.
 
Links:  White Paper
Download:  bipublisher_integration.zip

 

Amazon Store

The Amazon Store is a demonstration application based on Amazon.com's E-Commerce service. You can search for items from Amazon's entire catalog and sort by various means and paginate through the results.

This application utilizes the Manual Web Reference feature in Application Express 3.0. You can view these Web references by going to Shared Components > Web Service References.
 
Links:  screensnap, preview
Download:  amazon_store_1.0.zip

 

Google Maps

Application Express can be easily integrated with the Google Maps API. The Google Maps API allows you to create online mapping applications and incorporate geo-coding into them. It is the application that would result from the whitepaper Integrating Application Express with Google Maps.
 
Links:  screensnap, preview
Download:  google_maps.zip

 

Integrating with PayPal Payments Pro

This Application demonstrates how to integrate with PayPal's Website Payments Pro offering. It is the application that would result from the whitepaper Integrating Application Express with PayPal Payments Pro.
 
Links:  screensnap
Download:  paypal_1.0.zip

 

Integrating an RSS Feed

This demonstration application shows how Application Express can be used to consume RSS feeds.
 
Including an RSS (Really Simple Syndication) feed in your Application Express application is a simple two step process.  First, you retrieve the RSS document from the feed and and store it in a collection, and then you write a report against the collection.
 
Links:  screensnap, preview
Download:  RSSReader.zip

 

YouTube Integration

This Application demonstrates XML-RPC style Web Services, specifically integrating YouTube services. It is an expanded version of the application resulting from the whitepaper Using Oracle Application Express to Interact with XML-RPC Style Web Services.
 
Links:  screensnap, preview
Download:  YouTube_Integration.zip

 
 

Installation Instructions

  1. Ensure the 'Minimum Release' is the same or less than your Oracle APEX version (i.e. 2.2 code will install in 3.0 but not vice versa).
  2. Download the zip file associated with the desired application.
  3. Unzip and extract all files.
  4. Read the readme file.  If it is not the initial release of an application the changes will be described along with upgrade instructions.
  5. Access your target Workspace.
  6. Select the Application Builder.
  7. Click [Import >].
  8. Browse and locate the installer file, e.g. YouTube_Integration_installer.sql.
  9. When prompted, select to install supporting objects.
Terms of Use
Please review the OTN Terms of Use regarding downloading Third Party Content from Oracle Corporation before you download and/or install any application from this page.
 
The materials provided here are for sample use and are provided "as-is"; Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in connection with the use of these materials.
 
These applications are not part of Oracle Application Express software and are therefore not supported by Oracle Support.  Any issues with these can be discussed on the Application Express Forum.