DB2 - Problembeschreibung
Problem IC77406 | Status: Geschlossen |
PARAMETER MARKER FOR AN ARRAY TYPE IN AN ANONYMOUS BLOCK FAILS WITH SQL0408N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
An SQL0408N error is returned when a parameter marker is used in an anonymous block to pass a value with an array data type. Here is an example where the parameter marker in the anonymous block is input to a procedure in a CALL statement, though the error will be reported no matter how the parameter marker is used: create type myarray as integer array[10] DB20000I The SQL command completed successfully. create procedure myproc (in p1 myarray) begin end DB20000I The SQL command completed successfully. create procedure myproc2() begin declare v1 myarray; -- prepare st from 'begin call myproc(cast (? as myarray)); end'; -- execute st using v1; -- end DB20000I The SQL command completed successfully. call myproc2() SQL0408N A value is not compatible with the data type of its assignment target. Target name is "?". LINE NUMBER=1. SQLSTATE=42821 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users of DB2 LUW version 9.7 up to and including fix * * pack 4. * **************************************************************** * PROBLEM DESCRIPTION: * * An SQL0408N error is returned when a parameter marker is * * used in * * an anonymous block to pass a value with an array data type. * * * * Here is an example where the parameter marker in the * * anonymous * * block is input to a procedure in a CALL statement, though * * the * * error will be reported no matter how the parameter marker is * * * * used: * * * * * * * * create type myarray as integer array[10] * * * * DB20000I The SQL command completed successfully. * * * * * * * * create procedure myproc (in p1 myarray) * * * * begin end * * * * DB20000I The SQL command completed successfully. * * * * * * * * create procedure myproc2() * * * * begin * * * * declare v1 myarray; -- * * * * prepare st from 'begin call myproc(cast (? as myarray)); * * end';-- * * * * execute st using v1; -- * * * * end * * * * DB20000I The SQL command completed successfully. * * * * * * * * call myproc2() * * * * SQL0408N A value is not compatible with the data type of * * its * * assignment target. Target name is "?". LINE NUMBER=1. * * SQLSTATE=42821 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW version 9.7 fix pack 5 * **************************************************************** | |
Local-Fix: | |
There is not a local fix for this problem. The parameter marker representing an array data type must be removed from the anonymous block for execution of the anonymous block to succeed. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
Fix release: DB2 LUW version 9.7 fix pack 5 Fix commitment level: 999 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.07.2011 08.12.2011 08.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |