My Oracle Support Banner

String To Be Prepared Contains Invalid Use Of Parameter Markers (Doc ID 1163715.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Database Gateway for DRDA - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

After migrating from TG4DB2 to DRDA 11.2 SQL statements containing TRIM/UPPER and binds fails with error:

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]STRING TO
BE PREPARED CONTAINS INVALID USE OF PARAMETER MARKERS. {HY000,NativeErr = -418}
ORA-02063: preceding 2 lines from SYSC0_32


Changes

Migrating from TG4DB2 to DRDA 11.2

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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