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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: