Stored Procedures: Parse Options Page

Any changes you make to the parse options in this page apply to all stored procedures. You should parse the stored procedures in order for these changes to take effect. You can do this by choosing the Object -> Parse option from the menu. Alternatively, you can choose the Action -> Create Oracle Model option from the menu to re-create the Oracle Model.

The Parse Options page of the Stored Procedures property sheet features the following:

Auto-Select
Indicates that you want the parser to decide whether the stored procedures are converted to functions or procedures. It is selected by default. If you deselect the Auto Select option, the Function, Procedure, and Return Value options are enabled.

Function
Converts a T-SQL stored procedure to a PL/SQL function. If you want the stored procedures to be converted to functions, you should select the Function option, then enter a return value for the function.

Return Value
Choose Function, then enter a return value of the function. The default is zero.

Procedure
Converts a T-SQL stored procedure to a PL/SQL stored procedure. If you want the stored procedures to be converted to procedures, you do not need to enter a return value.

Generate Exceptions
Generates PL/SQL exception blocks in the converted stored procedure.

Generate Comments
Generates comments in the stored procedure.

Generate Debug Info
Generates debug information in the stored procedure.

Emulate @@TRANCOUNT
Emulates the T-SQL @@TRANCOUNT global variable by providing the number of currently active transactions for the current user. View the variable through DBA Studio by going to the globaPkg package within the omwb_emulation user. The package is automatically created with invokers rights. For more information about invokers rights, see the PL/SQL User's Guide Reference Release 2 (8.1.6) (Part Number A77069-01).

Add procedure name to local variables
Adds the stored procedure name as a prefix to the local variable by default. This helps you distinguish between local variables and column names.

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

Append procedure name to temp table
Appends the name of the stored procedure 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 stored procedure. 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 option to enable the parser to recognise that these words are object names. If you do not select this option, you encounter a ParseException. For more information about parser errors, see the Appendix of this online Help.

Type of Result Set
Select the result set type from the drop-down list. The following alternatives are available:

Parameter Handling
Select the parameter handling option from the drop-down list. The following alternatives are available:

Choose Apply to accept the changes that you made to the parse options.

Choose Revert to abandon the changes.