Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers : Basics of Java stored procedures : Advantages of stored procedures

Advantages of stored procedures

Stored procedures and triggers expand the flexibility and performance of applications that access the OpenEdge SQL environment. They provide a mechanism for storing a collection of SQL statements and Java program constructs that enforce business rules and perform administrative tasks in a database.
Stored procedures and triggers enhance applications by:
*Enabling a client application to perform a procedure with a single request instead of multiple requests for each SQL statement.
*Executing faster than a corresponding SQL script.
*Implementing elaborate algorithms to enforce complex business rules. The details of the procedure implementation can change without requiring changes in an application that calls the procedure.