Progress
Database Design
Guide


Java Stored Procedures and Triggers

A Java stored procedure is a group of SQL-92 statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries for execution on a database server.

A trigger is a special type of stored procedure that is automatically invoked when certain database events occur. Triggers are used to enforce referential integrity and business rules.

This chapter discusses stored procedures and triggers.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095