DB2 - Problembeschreibung
Problem IT08814 | Status: Geschlossen |
SQL0408N RETURNED TO A PL/SQL FUNCTION CALLED WITH ARRAY PARAMETER. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
PL/SQL Function: create or replace package body test_schema.test_pkg is function f_use_array(p_arr IN g_array_typ) return varchar2 is l_value varchar2(20); begin for i in p_arr.first .. p_arr.last loop l_value := l_value || ' ' || p_arr(i); end loop; return l_value; end; Java application calling the Function: call_fun_stmt = "BEGIN ? := TEST_SCHEMA.TEST_PKG.F_USE_ARRAY(?); fails with 'SQL0408N A value is not compatible with the data type of its assignment target' error. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 V10.5 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 Fix Pack 7 or higher. * **************************************************************** | |
Local-Fix: | |
Call the parameter marker with cast to the array data type: BEGIN ? := TEST_SCHEMA.TEST_PKG.F_USE_ARRAY(cast(? as test_schema.test_pkg.g_array_typ) | |
Lösung | |
Fixed in DB2 V10.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.05.2015 22.01.2016 22.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |