DP4DRDA gets sqlcode -805 when looking for package during dpsadpecPackageExistsCT (Doc ID 1970054.1)

Last updated on APRIL 29, 2015

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.1 and later
Linux x86-64

Symptoms

When mapping from NUMBER->BIGINT with multiple columns being typemap'ed but returning Decimal Float.

Connection from DB2 v10 on z/OS,
through "Oracle Database Provider for DRDA" (DP4DRDA) 12.1.0.2 running on Linux x86-64,  
to   Oracle 11.2.0.4 Database on Linux x86-64.

The DP4DRDA trace shows sqlcode -805 is returned when looking for package, during dpsadpecPackageExistsCT:

Entering dpsadpecPackageExistsCT at 2015-02-05 09:37:18.945061000
dpsadpecPackageExistsCT: Looking for package TENV4_FIN TST4.OMSSORAI [19BBFC26049B1119]  
MyMemoryAlloc(4200) => 0x102b0860
MyMemoryAlloc(4240) => 0x102b18d0
1.0: OCIStmtPrepare2(@0x102b11d8,0x527c40,82,L=1) -> RC=0
2.0: OCIBindByName(h0x102b11d8,'doexist_rc',0x7fff0a9f77d0,4,3) -> RC=0
2.0: OCIBindByName(h0x102b11d8,'collid',0x102aa660,4,1) -> RC=0
2.0: OCIBindByName(h0x102b11d8,'pkgid',0x102aa630,8,1) -> RC=0
2.0: OCIBindByName(h0x102b11d8,'cnstkn',0x102aa708,8,23) -> RC=0
3.0: OCIStmtExecute(h0x102b11d8) -> RC=0
4.0: OCIStmtRelease(h0x102b11d8) -> RC=0
Bind doexist_rc(1) to -20983
Bind collid(2) to TST4
Bind pkgid(3) to OMSSORAI
Bind cnstkn(4) to 19BBFC26049B1119
Exiting  dpsadpecPackageExistsCT, rc= 0 at 2015-02-05 09:37:19.291833000
dpsadpecPackageExistsCT: rc=0, exists_rc=-20983
At send_sqlcode_805
Entering SQLCASet, SQLCA= 0x10194748 at 2015-02-05 09:37:19.291926000
SQLCA item 228
Entering SQLCASet, SQLCA= 0x10194748 at 2015-02-05 09:37:19.291964000
SQLCA item 104
Exiting  SQLCASet, RC= 0 at 2015-02-05 09:37:19.291999000
sqlerrmsg: TENV4_FIN.TST4.OMSSORAI.19BBFC26049B1119
SQLCA item 610
sqldctok: TENV4_FIN.TST4.OMSSORAI.19BBFC26049B1119
Exiting  SQLCASet, RC= 0 at 2015-02-05 09:37:19.292118000
Calling dpsadass_SQLCASet...
Entering SQLCASet, SQLCA= 0x10194748 at 2015-02-05 09:37:19.292152000
SQLCA item 101
SQLCASet: sqlcode=-805  

 

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