My Oracle Support Banner

Calling TG4DRDA or DG4DRDA Gtw$_bind_pkg Against AS400 Gives Ora-00942 errp=QSQSCPKG (Doc ID 395561.1)

Last updated on FEBRUARY 04, 2022

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
 


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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.