Run the command script to the right.
The customer package contains types, procedures and functions related to customer management:
- The type CUSTOMER_RECORD contains all information about the customer
- The reference cursor SEARCH_REFCURSOR is used for exchanging an open cursor between functions and procedures
- The associative array SEARCH_CRITERIA is used for storing the pairs of search arguments and search values
- The function SEARCH_CUSTOMER_RECORES returns a list of the customers in the form of the reference cursor
- The procedure CREATE_CUSTOMER creates customers with verification of duplicate values
- The procedure GET_CUSTOMER returns CUSTOMER_RECORD type based on customer_id
- The procedure GENERATE_PROMOTION generates a list of customers who are eligible for the companys promotion based on the birth date
Features of this package include:
- Anchor Data types:
- Advanced type support:
- TYPE ... IS RECORD ...
- TYPE ... IS REF CURSOR
- TYPE ... IS TABLE OF ... INDEX BY ...
- Dynamic statement execution:
- Built-in Functions:
- Exceptions:
- EXCEPTION ... WHEN ... THEN ...
- RAISE
- and more...
You should see several successful completion statements to the right.