DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare conditions a SQL0779N error might be return if label 
specified in GOTO statement is followed by array collection 
method 
TRIM/DELETE/EXTEND. 
The following example illustrates the problem. 
 
declare 
 TYPE tArray IS TABLE OF VARCHAR2(10); 
 Arr1 tArray; 
begin 
  GOTO LABEL1; 
  <<LABEL1>> 
  Arr1.delete; 
end; 
 
This situation might also occur in case of label being followed 
by assignment of DBMS function like DBMS_SQL.OPEN_CURSOR 
mycur := DBMS_SQL.OPEN_CURSOR ;

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use LABELs in PL/SQL.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V9.7 FixPack 10 or later.              * 
****************************************************************

Please make sure that label is not followed by array collection 
methods.

This problem was first fixed in DB2 V9.7 FixPack 10.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC99740 IC99745 
follow-up : 

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

18.02.2014
17.11.2014
17.11.2014

9.7.FP10