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

on to Part 2[/szb]