Overloading Packaged Procedures
In this assignment, you create packaged procedures to retrieve shopper
information. Brewbean’s is adding an application page where customer service
agents can retrieve shopper information by using ID or last name. Create a
package named SHOP_QUERY_PKG containing overload procedures to perform
these lookups. They should return the shopper’s name, city, state
...[Show More]
Overloading Packaged Procedures
In this assignment, you create packaged procedures to retrieve shopper
information. Brewbean’s is adding an application page where customer service
agents can retrieve shopper information by using ID or last name. Create a
package named SHOP_QUERY_PKG containing overload procedures to perform
these lookups. They should return the shopper’s name, city, state, phone number,
and e-mail address. Test the package twice. First call the procedure with shopper
ID 23 and then call it with the last name Ratman. Both test values refer to the
same shopper, so they should return the same shopper information. (Use slide 23
then test/ invoke the package first by id=23, then by name= Ratman)
[Show Less]