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:
Single Result Set: Converts a T-SQL stored procedure into a PL/SQL package and a PL/SQL procedure/function.
Power Builder: Creates an Oracle stored procedure that supports result sets for PowerBuilder.
Multiple Output Arguments: Converts a T-SQL stored procedure into a PL/SQL procedure/function.
Parameter Handling
Select the parameter handling
option from the drop-down list. The following alternatives are available:
Default: Input arguments are changed to IN and local variables are used for each argument. Changes to the IN argument are not visible to the caller once the stored procedure returns.
Make variable In-Out: The input argument type for the argument is changed to IN OUT so that the new value of the argument can be returned to the caller. The default value is assigned to the argument within the stored procedure.
Add In-Out Variable: An extra IN OUT argument is added in which the new value is returned to the caller. The main disadvantage of this method is that the caller must be changed to include the extra argument(s) added.
Choose Apply to accept the changes that you made to the parse options.
Choose Revert to abandon the changes.