DB2 FOR LUW / DB2FORLUW / A50 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 V10.5 users                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.5 Fix Pack 7 or higher.                   * 
****************************************************************

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)

Fixed in DB2 V10.5 Fix Pack 7.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.05.2015
22.01.2016
22.01.2016