In this module, you will learn about creating procedures using PL/SQL. Procedures are more versatile than functions. While a function returns a single value, a procedure can return no value, or multiple values using outgoing parameters. A function has severe restrictions against modifying database data, while a procedure is allowed to modify data. During this lesson, you will create a procedure and then add a call to a function within that procedure.

By the end of this module, you will know how to:

1. Distinguish between a function and a procedure
2. Create a procedure to calculate a percentage and an average for a given sales transaction
3. List capabilities and restrictions of calling other procedures
4. Add a function to a procedure

You also will use a simulation to build your own procedure for the House-O-Pets course project.