Part 1: A simple multi-tiered Oracle package structure
The software architecture below is a basic three tier structure comprising a Table Encapsulation Layer, Object Layer and an Oracle Type (an object).
Note at this point that each of the database objects has a distinct and meaningful function.
Table: stores data
Table Encapsulation Package: accesses the table using DML (SELECT, INSERT, UPDATE, DELETE)
Object Package: accesses the Table Encapsulation Package and populates the Object
Oracle Object: carrier for data to pass up to Java