Query 11g DB from Stored Procedure Call through Oracle Database Provider for DRDA returns Sqlcode -440

(Doc ID 2005181.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

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


While trying to query Oracle Database from stored procedure CALL,
with connection "from" DB2 v10 (and COBOL) on z/OS through ODP4DRDA on Linux x86-64
"to" Oracle Database on Linux x86-64, results in sqlcode -440;

The code currently only supports CALL with bind variables and should support
literals, NULL, and expressions, as well as bind variables for CALL.

The -440 trace file (pp_22020_drdaas.trc) shows the following messages:


Entering dpsadrexCSqlstt_proc_desc, Cursor= 0x49bc708 at 2015-02-25
my_schnm="MKT", ln=3
MyMemoryAlloc(4200) => 0x49ce040
OCIHandleAlloc(@h0x49cee48,OCI_HTYPE_DESCRIBE) -> RC=0
Looking for standalone procedure MKT.ICIS_WRITE_TO_TRANSACTION_LOG with 5
is_synonym: schema=MKT, prcnm=ICIS_WRITE_TO_TRANSACTION_LOG
There are 0 seemingly acceptable procedure(s) with name
OCIHandleFree(h0x49cee48,OCI_HTYPE_DESCRIBE) -> RC=0
Exiting  dpsadrexCSqlstt_proc_desc, RC= 1 at 2015-02-25 16:35:56.635160000
SQLCASet: sqlcode=-440



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