Database triggers
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Database triggers are code that an application associates
with a database object and an action. For example, writing a record
can cause code associated with that object or action to execute.
The DataServer allows your applications to access both OpenEdge and
Oracle triggers. In an application that combines both OpenEdge and
Oracle triggers, ABL trigger (CREATE, UPDATE, DELETE)
executes first. As each OpenEdge trigger executes successfully,
the DataServer passes the request to Oracle, and the Oracle trigger
(INSERT, UPDATE, DELETE)
executes. In the case of an Oracle BEFORE trigger,
the Oracle trigger executes after the DataServer passes the request
but before the insert, update, or delete occurs. When you use the OpenEdge DB-to-Oracle
utility to convert an OpenEdge database to Oracle, the utility
does not convert ABL triggers into Oracle triggers. The triggers
remain in ABL, and are part of the schema holder.