Progress
Database Design
Guide
Triggers versus Stored Procedures
Triggers are identical to stored procedures in many respects. There are three main differences:
- Triggers are automatic.
When the trigger event (INSERT, UPDATE or DELETE) affects the target table, the Java code contained in the body of the trigger executes. A stored procedure must be explicitly invoked by an application or another procedure.
- Triggers cannot have output parameters or a result set.
Since triggers are automatic, there is no calling application to process any output they might generate.
- Triggers have limited input parameters.
The only possible input parameters for triggers are values of columns in the rows affected by the trigger event.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |