devxlogo

Pre-Compiled Database Triggers

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.

devx-admin

Share the Post: