May 4, 2000
Pre-Compiled Database Triggers
Many programmers create stored procedures out of large bodies of database trigger codes. This has primarily been because while stored procedures are stored in compiled form, database triggers are compiled each time they get fired. But you no longer have to split your database trigger code into multiple procedures because Oracle7.3 PL/SQL2.3 now supports pre-compiled database triggers. Thus pre-compiled database triggers speed up the performance of database triggers.