Oracle APEX Tutorial 6 – Creating the Base Application & Service – P1 – Video Training

kevin.landonTechnical Tips5 Comments


As the world moves forward, there is a higher need for more information. However, it is a near impossible task to create and manage all this information yourself. Sometimes, it’s easier to use freely available services and information feeds provided by others. One such ‘feed’ is a Web Service. By sending a properly formed request to another group over the web, you can receive information back, and display it on your screen. A popular and easy to visualize example of this is getting the local Movie Theater times and titles for current movies. This tutorial will show how to do this. It is recommended that you review our article APEX Tutorial Preparation and OEHR Sample Data Install before proceeding with this tutorial.

Part 1 – Creating the Base Application and Services


High Level Steps

1) Create Base Application (0:30)
2) Specify Proxy Settings (optional) (2:18)
3) Create a Web Service by WDSL (2:53)
4) Dreate a Web Service Manually (6:00)

The times in parenthesis are approximate start times for that step

Notes and Resources

Web Services

Web Services are somewhat like the web itself, and can be transient in nature. Due to this, the information presented in this tutorial is accurate as of the time the tutorial was made. However, there may be changes in the Web Service link, procedures, returned data and other factors since the creation of this document. Web Services can by found by either manually entering the information needed (as we are doing in this tutorial) or by use of the UDDI (Universal Description, Discovery and Integration) registry, which is a directory where businesses have submitted their available Web Services information for others to browse and use.


SOAP is the abbreviation for Simple Object Access Protocol. It is an attempt to provide a platform neutral way to exchange requests and results across the Internet. The SOAP standards are maintained by the W3C, and may be superseded in future protocol standards.

Testing Manual Services

Whenever you create and test a manual service it accomplishes two things. One it tells you if you are getting back the correct information, and two, it allows you to find the information references you may need later when building the displayed report. In our case, embedded in the returned results for the Movie Info service there are a few things we need to take note of. One is the ‘base node’, another is the ‘namespace’, also there is the ‘XPath’ and the ‘interesting elements’ All of these will be used in the creation of the end report, so it’s important to know them. Of course, this means that you should have a good idea of the data you need from the web service before you go invoking it.

Code and Pasted Text

WSDL Location Field

Manual Service Creation URL and Action

Manual Creation SOAP Envelope

<!--?xml version="1.0" encoding="UTF-8"?-->

SOAP Response


5 Comments on “Oracle APEX Tutorial 6 – Creating the Base Application & Service – P1 – Video Training”

  1. Hey, Question please answer asap. Do I have to create the data object (tables) for these movie theaters and zup codes

  2. Hi,

    I am going through the Web-Services tutorial and at the stage of creating a new web service and keyed the WSDL Location. When clicking on Next I get the following error:

    “The WSDL document was unretrievable because either the URL you supplied was invalid, your environment requires a valid proxy server address for HTTP requests and you have not defined one for this application, or a wallet needs to be configured for this instance of Application Express for HTTPS requests.”

    I am not using a proxy server to connect to the internet and I assume the link you have is correct (URL: So the only option from the list is setting up a Wallet. Do you have any recommended tutorials on setting this up?

    I am using Oracle APEX 4.1.

    Many thanks

  3. Hi Jay,

    I have personally tested this url and find it working. You may need to check your proxy settings such that the database can make a http call-out. Please use a sample utl_htp call to verify that you are able to make a http call out from your database.

  4. Hi! I’m trying to parse a local XML with APEX similarly to the way it does with the Web Service. Does anyone knows if there’s a way to do it? Thanks in advance 🙂

  5. Hi Dimitri/All,
    We need to approve/reject the workflow notification of oracle EBS using smartphone.
    Option 1
    We have published the oracle EBS native PL/SQL API as an web services.How to use the APEX application to approve/reject it in smartphones?

    Option 2
    I can think of accessing oracle EBS login page from mobile application of APEX using browser?
    (Next step is User authentication will be by native EBS authentication after that next responsibility page
    Finally This responsibility “Workflow approval manager” will help me to approve/reject workflow)

Leave a Reply

Your email address will not be published. Required fields are marked *