100%(4)4 out of 4 people found this document helpful
This preview shows page 1 - 2 out of 3 pages.
Ramoi Hammond Database Development II Chapter Seven Hands-On-Assignments Part I Assignment 7-4: Using Packaged Variables In this assignment, you create a package that uses packaged variables to assist in the user logon process. When a returning shopper logs on, the username and password entered need to be verified against the database. In addition, two values need to be stored in packaged variables for reference during the user session: the shopper ID and the first three digits of the shopper's zip code (used for regional advertisements displayed on the site). 1. Create a function that accepts a username and password as arguments and verifies these values against the database for a match. If a match is found, return the value Y. Set the value of the variable holding the return value to N. Include a NO_DATA_FOUND exception handler to display a message that the logon values are invalid. 2. Now place the function in a package, and add code to create and populate the packaged variables specified earlier. Name the package LOGIN_PKG.