Testing PLSQL Web Services with SoapUI

In this introductory tutorial we investigate how to use the automated interface testing tool SoapUI. In order to do this we need a SOAP web service to test and we will create this by using an Oracle XE database and a PLSQL procedure. Using Oracle’s Native XML DB web services it is very easy to expose a PLSQL procedure as a web service.
This step by step tutorial will cover:

1. How to download and install the FREE version of Oracle called Oracle XE,
2. How to download and install a FREE IDE called SQL Developer,
3. All the DBA tasks required to set up accounts and create the development environment,
4. How to create a PLSQL procedure,
5. How to expose the PLSQL procedure using Oracle's Native XML DB web services,
6. How to download and install the FREE open source interface testing tool SoapUI,
7. A quick over view of WSDL – Web Service Description Language,
8. How to write an automated testing suite to fully exercise the web service.

This excellent tutorial will expand your knowledge and demonstrate the power of Oracle’s native web services. It will also teach you a valuable open source automation testing skill - How to use SoapUI.

Read it today!