My Oracle Support Banner

SQLCODE -418 occurs on the TG4DB2 side after upgrade of Oracle DB server to 10.2.0.4 (Doc ID 814033.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Database Gateway for DB2 - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
Operating System Dependent Interface - Version 10.2.0.3.1 to 10.2.0.3.1
IBM z/OS on System z
Operating System Dependent Interface - Version: 10.2.0.3.1 to 10.2.0.3.1
IBM z/OS (OS/390)

Symptoms

When the database server was upgraded to 10.2.0.4 and fix for BUG 4864563 has been applied, the Transparent Gateway for DB2 (TG4DB2) started getting the error below:

ERROR
ORA-28500 accompanied with SQLSTATE = 42610

The following shows in the gateway trace:

DSNT408I SQLCODE = -418, ERROR: A STATEMENT STRING TO BE PREPARED CONTAINS AN
INVALID USE OF PARAMETER MARKERS
DSNT418I SQLSTATE = 42610 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOBFA SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 30 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'0000001E' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION


Changes

 

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
Changes
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.