print Printer View e-mail E-mail this page Bookmark Bookmark

Oracle Application Express 		Return to Oracle APEX Home
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.
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 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.
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy