My Oracle Support Banner

SQLCODE=-418 When Executing Procedure After Database Upgrade From 9i to 10g (Doc ID 763376.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database Gateway for DB2 - Version 10.2.0.3.0 and later
Information in this document applies to any platform.
Oracle Transparent Gateway for DB2 - Version: 10.2.0.3.0
"Checked for relevance on 22-Jul-2011"


Symptoms

A plsql procedure is raising ORA-28500 after  the Oracle Database has been upgraded from version 9i to
version 10.2.0.

The gateway trace is showing the following error message :
hoapars rc=409, sqlcode=-418
fdsgem2: errcode=fffffe5e
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

 

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

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.