|
Problem IT19200
|
Status: Geschlossen |
ERROR 9700 'ROUTINE AMBIGUOUS: MORE THAN ONE ROUTINE RESOLVES TOGIVEN SIGNATURE' WHEN EXECUTING A DATABASE ROUTINE FROM JDBC
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.02.2017
10.07.2017
10.07.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
12.10.xC9
|
| Problem behoben lt. FixList in der Version |
