Column-based triggering

An enhancement to the row-based triggering functionality is column-based triggering. It enables you to trigger an event to occur on a row when a particular column condition is met. This functionality is available in both the m4ora.sql and the m4ora_col.sql scripts. To use this functionality to trigger an Oracle database watch event for a map when a column condition is met, supply the column condition extension of the SQL WHEN expression in the Trigger Specification dialog of the Database Interface Designer. The portion of the WHEN expression that appears after column condition is the SQL clause that is passed to the Oracle database for processing.

Refer to Oracle documentation for the WHEN clause syntax when using it in a trigger definition.

For information on installing the m4ora.sql and the m4ora_col.sql scripts, refer to "Installation Requirements".

To see how to construct the WHEN expression for column-based triggering, see the example in the Format of the When Expression section.