Testing PLSQL Web Services with SoapUI

by Richard Thrust

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 database web services it is very easy to expose a PLSQL procedure as a web service.
This step by step tutorial will

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 database 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!

Tutorial Contents

Introduction
Before You Start
Chapter 1 – How to Download and install Oracle XE
1.1 Download and install Oracle XE
1.2 Recap
Chapter 2 – How to download and install SQL Developer
2.1 Download and install SQL Developer
2.2 Recap
Chapter 3 – Required DBA tasks
3.1 Creating an Oracle account
3.2 Creating a SQL Developer connection
3.3 Recap
Chapter 4 - How to create a PLSQL procedure
4.1 How to Create a PLSQL procedure
4.2 Testing the PLSQL procedure
4.3 Recap
Chapter 5 - How to expose the PLSQL procedure as a web service
5.1 How to set up a web service
5.2 The WSDL file URL
5.3 Browsing the WSDL
5.4 What is a WSDL file?
5.5 Recap
Chapter 6 - How to download and install the SoapUI testing tool
6.1 Downloading SoapUI
6.2 Installing SoapUI.
6.3 Recap
Chapter 7 - How to write a SoapUI testing suite
7.1 Overview
7.2 Summary of steps to create a SoapUI project
7.3 Create a new SoapUI project
7.4 Adding more test cases
7.5 Configuring Test Case Authorisation
7.6 Configure test case assertions
7.7 Executing a Test Suite
7.8 Recap
Chapter 8 – Non-GUI SoapUI testing
8.1 Executing the test suite in batch
8.3 Recap
Chapter 9 – Software Configuration
9.1 Windows
9.2 Java Version
9.2 Oracle XE
9.3 SQL Developer
9.4 SoapUI
Chapter 10 – In conclusion
Bonus Material related to this eBook
More titles from Richard Thrust

59 pages, Kindle Edition

First published March 5, 2014