|
Problem IT19200
|
Status: Closed |
ERROR 9700 'ROUTINE AMBIGUOUS: MORE THAN ONE ROUTINE RESOLVES TOGIVEN SIGNATURE' WHEN EXECUTING A DATABASE ROUTINE FROM JDBC
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Executing a routine with parameters (function or stored
procedure) may fail with error:
-9700 Routine (routine_name) ambiguous - more than one routine
resolves to given signature.
This problem happens when an argument (or its source type or
parent
type) has implicit casts to the parameters of two or more
routines.
The error appears even if the routine is unique in the database.
The exception generated on JDBC looks like:
java.sql.SQLException: Routine (%s) ambiguous - more than one
routine resolves to given signature.
at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:492)
at
com.informix.jdbc.IfxCallableStatement.handleParameterName(IfxCa
llableStatement.java:2451)
at
com.informix.jdbc.IfxCallableStatement.setString(IfxCallableStat
ement.java:1786 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC9 *
**************************************************************** |
| Local Fix: |
To temporarily workaround the problem, recreate the routine on
the server side. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.02.2017
10.07.2017
10.07.2017 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC9
|
| Problem solved according to the fixlist(s) of the following version(s) |
