RelationalDBDesign RelationalDBDesign


Creating Packages   «Prev  Next»

Create Package - Exercise

Making the package body


On Your Own: Create a package


Objective: Create a package out of a procedure and function

Exercise scoring

No score. Optional exercise.

Background/overview

This is the same as the previous exercise in this lesson. The difference is that you will run the results in your own database schema to test the syntax.

Download files

Download the package_exercise.sql file from the Resources page for the source code of the procedure and functions to be included in your package.

Instructions

Using the downloaded file and your own text editor, create the two commands needed to generate the package specification and package body. Create your own name for the package, procedure, function, and all parameters. Document your code by explaining how you used parameters and variables in the package. Execute the code in your PETSTORE schema.

Submitting your exercise

This is an On-your-own exercise. Do not submit your results.