Trigger: Parse Options Page

If you modify the parse options for a particular trigger, you should parse the trigger in order for these changes to take effect. You can do this using either the right mouse button or the Parse menu item in the Object menu. Alternatively, you could use the Create Oracle Model item in the Action menu to re-create the Oracle Model.

The Parse Options page of the property sheet for a particular trigger in the Source Model features the following check boxes:

Auto-Select: This check box is disabled for triggers.

Function: This check box is disabled for triggers.

Return Value: This check box is disabled for triggers.

Procedure: This check box is disabled for triggers.

Generate Exceptions: Generates PL/SQL exception blocks in the converted trigger.

Generate comments: Generates comments in the trigger.

Generate Debug Info: Generates debug information in the trigger.

Add procedure name to local variables: By default, all local variables within the trigger are prefixed with the name of the trigger which helps to distinguish local variables from column names.

Use column name aliases in reference cursor: By default, column names are used to define components within the record structure for result sets. This option forces the Migration Workbench to use its alias whenever possible.

Append procedure name to temp table: Appends the name of the trigger to the temporary table.

Generate Oracle8i temp tables: Uses Oracle8i syntax to create temporary tables. Otherwise, creates permanent tables with the same name as the temporary tables in the trigger. The permanent tables have a column added for session ID.

Allow 'Reserved Words' in table names: Some identifiers such as ERROR, DATETIME, and OUTPUT are not official T-SQL reserved words but have meaning in T-SQL syntax. If your T-SQL code uses these words as object names, you must select this check box to enable the parser to recognise that these words are object names. If you do not select this check box, you will encounter a ParseException. See the Appendix of this online Help for more information about parser errors.

Type of result set: This field is disabled for triggers.

Parameter Handling: This field is disabled for triggers.

Any changes that you make to the parse options can be applied or abandoned by using the Apply or Revert button.