#rodsays #plsql
Add this:

WHENEVER SQLERROR EXIT

This means that if your table check generates an ORA-20001 error (or any other sql errors), nothing else will get run. Just in case someone runs the entire script. Without this, it would keep running everything after the error.

#rodsays Always use "TIMESTAMP(6) WITH TIME ZONE". TIMESTAMP does not store time zone information -- it should only be used when the column value is directly tied to a single time zone (e.g. LASTUPDATETIMEINGMT).

#plsql

#rodsays Avoid the use of select * in any new repository code. Explicitly specify the columns you need. This is to avoid problems with the oracle data provider if we change the table structure while the code is running.

#rodsays We should keep generic things truly generic and not to compromise their generic nature under the pretense of adding extensions.