Calling TG4DRDA or DG4DRDA Gtw$_bind_pkg Against AS400 Gives Ora-00942 errp=QSQSCPKG

(Doc ID 395561.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 9.2.0 to 11.1
Information in this document applies to any platform.
Oracle Transparent Gateway for IBM DRDA - Version: 9.2 to 11.1
Checked for relevance 23-Aug-2010


Symptoms

 

Trying to bind TG4DRDA or DG4DRDA GTW$_BIND_PKG package on an AS400 and gives the error similar to -

EXECUTE GTW$_BIND_PKG@DB_LINK;
BEGIN GTW$_BIND_PKG@DB_LINK; END;

*
ERROR at line 1:
ORA-00942: table or view does not exist
TG4DRDA v10.1.0.5.0 grc=0, drc=-942 (839C,0000), errp=QSQSCPKG
sqlcode=-204, sqlstate=42704, errd=F3F4F0F1,0,0,0,0,0
errmc=QSYS.ORACLE,COLLECTION
ORA-06512: at line 1

The gateway name will vary according to the version.
.

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