Write business rules using conditions (T-SQL), message texts (plain text) and actions (T-SQL) and store them in a database table. These rules will be automatically called by a general purpose trigger generated dynamically by the Software.
File List:
@PSC_ReadMe_954_5.txt
1Kb
ZPTrigger_EN.doc
45Kb
zptrigger.sql
127Kb
Similar code
Disable a trigger for a specific user
(Popularity: ) : Okay, okay... "disable" is too strong a word. The trigger still fires, but it just doesn't do anything. Via the USER built-in PL/SQL function, you can easily bypass trigger activity for a user. This example shows how. Build "selective firing" into your database triggers
(Popularity: ) : PL/SQL example with narrative that illustrates how to build "selective firing" into database triggers via an outermost, enclosing conditional that evaluates user ID.
Code Library
) : Okay, okay... "disable" is too strong a word. The trigger still fires, but it just doesn't do anything. Via the USER built-in PL/SQL function, you can easily bypass trigger activity for a user. This example shows how.