Creating Packages   «Prev  Next»

Executing Components of a Package - Exercise

On Your Own Exercise: Course project test your package

Objective: Test the package you created on your own database.

Exercise Scoring

An On Your Own exercise is a good way for you to practice the skills you have just learned in this module.
It is not scored and it is an optional hands-on exercise that you can do if you have access to the optional hardware and software for this course.

Background and Overview

If you have a database and actually created a package in the PETSTORE schema in the previous lesson, go ahead and write the PL/SQL block to test your package. Look at the simulation in this lesson for hints.

Download files

Download the PETSTORE schema files from the Resources page if you plan to install them into your own database.


Run the test on your own database at home.


If you need more hints, complete the simulation in this lesson.