Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does the Migration Workbench handle the @@TRANSTATE global variable?

April 26, 2017global migration workbench

0

Posted

How does the Migration Workbench handle the @@TRANSTATE global variable?

1 Answer

0

Posted

The @@TRANSTATE global variable is treated as a normal variable. There is no Oracle Server equivalent. Transactions in an Oracle Server are either complete or they fail. Errors in an Oracle Server are handled through exceptions and SQLCODE. See Also: For more information, see the PL/SQL User’s Guide and Reference. Triggers and Rules The following questions are about SQL Server and Sybase Adaptive Server triggers and rules.