Try OpenEdge Now
skip to main content
SQL Development
Stored Procedures and Triggers
 

Stored Procedures and Triggers

Stored procedures are Java routines that are executed by the OpenEdge SQL engine. A stored procedure is explicitly invoked by a client application, another stored procedure, or a trigger procedure. SQL limits recursive invocation of a stored procedure to five levels.
This chapter describes when and how to use stored procedures, as detailed in the following sections.
* Setting up OpenEdge SQL for stored procedures and triggers
* Basics of Java stored procedures
* Stored procedure fundamentals
* Writing stored procedures
* Working with triggers