DB2 CONNECT / DB2CONNCT / 970 - DB2

CREATE OR REPLACE PACKAGE BODY may fail with SQL0601N if the 
body contains a cursor variable.  This will happen if the cursor 
variable already exists in the PL/SQL package.  For example: 
 
  create or replace package pack1 as end 
  DB20000I  The SQL command completed successfully. 
 
  create or replace package body pack1 as 
    cursor c1 is (select ibmreqd from sysibm.SYSDUMMY1); -- 
  end 
  DB20000I  The SQL command completed successfully. 
 
  create or replace package body pack1 as 
    cursor c1 is (select ibmreqd from sysibm.SYSDUMMY1); -- 
  end 
  SQL0601N  The name of the object to be created is identical to 
  the existing name "SCHEMA.PACK1.C1" of type "VARIABLE". 
  LINE NUMBER=3. SQLSTATE=42710 
 
This second CREATE OR REPLACE should succeed and replace the 
definition of the cursor variable PACK1.C1.

The fix is provided in the v97fp5

Drop and recreate the PL/SQL package: DROP PACKAGE PACK1

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

not known / see Local fix

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

18.05.2011
12.12.2011
12.12.2011