Post Update Trigger Causes Stored Procedure To Fail With Ora-28500 Using Gateway For SQL*Server (Doc ID 377747.1)

Last updated on FEBRUARY 23, 2011

Applies to:

Oracle Database Gateway for SQL Server - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 12-Jan-2011***

Symptoms

A customer has a stored procedure which selects from a table on SQL Server.
The stored procedure works without any problems.
When he enables a trigger he gets the following error



ERROR at line 1:
ORA-04092: cannot ROLLBACK in a trigger
ORA-06512: at "SCOTT.ACTUALIZAPAGOSAESCOLARIS", line 47
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]DRV_Execute:
ORA-02063: preceding 2 lines from TG4MSQL.WORLD
ORA-06512: at "SCOTT.USAB_ACTIVACION_PAGOS", line 11
ORA-04088: error during execution of trigger 'SCOTT.USAB_ACTIVACION_PAGOS'











Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms