My Oracle Support Banner

Error Calling Stored Procedure with DB2 Type 4 Driver (Doc ID 1470805.1)

Last updated on OCTOBER 14, 2019

Applies to:

Oracle Insurance Policy Administration J2EE - Version 8.0.16 and later
Information in this document applies to any platform.

Goal

Why does the following error occur when a stored procedure is executed (for Cycle), after implementing a Type 4 DB2 driver:

com.ibm.db2.jcc.am.SqlException: [jcc][10100][10910][3.61.75] java.sql.CallableStatement.executeQuery() was called but no result set was returned.
Use java.sql.CallableStatement.executeUpdate() for non-queries. ERRORCODE=-4476, SQLSTATE=null

Solution

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
Goal
Solution


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