How does the Migration Workbench handle the @@TRANCOUNT global variable?
You can set the emulation of the @@TRANCOUNT global variable on or off by choosing the Object > Parse option within the Migration Workbench. When you have selected the parser option, each reference to the @@TRANCOUNT variable within the SQL Server stored procedure is replaced with a reference to the omwb_emulation.globalPkg.trancount packaged variable within the destination Oracle database. However, if you do not select the Emulate @@TRANCOUNT variable parser option, the @@TRANCOUNT variable is treated as a normal variable. The following example compares the SQL Server statement with the equivalent Oracle Server statement when you select the Emulated @@TRANCOUNT variable option in the parse option. SQL Server Statement IF @@trancount > 100 Oracle Statement IF omwb_emulation.globalPkg.trancount > 100 Note: You access the emulated variable through the typical user.package.variable format. The SQL Server statements that affect the value of the @@TRANCOUNT variable, for example BEGIN TRANS
