DP4DRDA gets sqlcode -805 when looking for package during dpsadpecPackageExistsCT
(Doc ID 1970054.1)
Last updated on AUGUST 31, 2023
Applies to:
Oracle Database Provider for DRDA - Version 12.1.0.1 and laterLinux 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
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
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 |