Installation requirements
Before you can take advantage of the database triggering functionality, either one of three database-specific installation scripts must be run by a system administrator:
Note: This is a one-time only operation except for a possible
unexpected Launcher shutdown. For more information about that scenario, refer to Handling Unexpected Shutdowns.
- m4ora.sql (for Oracle)
- m4ora_col.sql (for Oracle)
- m4sqlsvr.sql (for Microsoft SQL Server)
Executing the respective script installs the database objects required for database triggering:
- tables that track "watch" events Four tables are added to your database. These are required for the triggering functionality. For more information about these tables, refer to Tables created for triggering.
- stored procedures that interface to the tables
- (for Microsoft SQL Server only) extended stored procedures that contain signaling logic
- (for Oracle only) public synonyms for tables and stored procedures
- (for Oracle only) sequences that generate unique trigger IDs
Certain privileges must be granted to the user running the database card triggers. The specific details for this and additional information are presented at the beginning of each script.