Chapter – II

Tables And Exception Propagation

(Informatics Practices)

PL/SQl TABLEs combine characteristics of SQL tables and C/Pascal arrays.
Like SQL tables:

• consist of records (must have a numeric primary key)
• can grow/shrink as elements are added/removed

Exceptions

An exception is an unusual/erroneous condition encountered during execution:

• system error (e.g. "out of memory")
• error caused by user program
• warning issued by application

PL/SQL's exception handling allows these to be handled "cleanly" in a central place.

Syntax for exception handlers:
     BEGIN
          ... Statements ...