DG4MQ DG4MQ Issues With Triggers When AUTHORIZATION_MODEL Is Not Set To COMMIT_CONFIRM
Last updated on JANUARY 18, 2017
Applies to:Oracle Database Gateway for WebSphere MQ - Version 10.2.0.1 and later
Information in this document applies to any platform.
While executing a trigger or some auto-commit PL/SQL code that references MQSeries objects via Database Gateway for Websphere MQ (DG4MQ) the following error is returned:
ORA-06512: at "SH_PLSQL_OWNER.MQ$INTERFACE", line 1154
ORA-20001: MQ$INTERFACE.qopen:ORA-28509: unable to establish a connection to non-Oracle system
ORA-06512: at "SH_PLSQL_OWNER.RUN_ENQUEUE", line 7
ORA-06512: at "SYSTEM.TEST_OPG_TRG", line 8
ORA-04088: error during execution of trigger 'SYSTEM.TEST_OPG_TRG'
This is a new install of DG4MQ and the execution of trigger code that involves MQSeries via the gateway.
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