Run the command script to the right.

In order to perform the benchmark, this step will create two new stored procedures that will wrap the PL/SQL and SQL PL stored procedures you created previously. By wrapping the stored procedures a fair comparison will be assured because everything will be run in the database, minimizing outside interference.

The stored procedures have three steps that will be your benchmark workload, they are:

  1. Create 25 Customers
  2. Create 50 Products
  3. Create 100 Orders based on the random content of the shopping cart

You should see successful completion messages in the console window to the right.