|
Problem IT10121
|
Status: Closed |
DB2 FAILS TO REINITIALIZE THE PL/SQL PACKAGE AFTER RECOMPILATION OF THE PACKAGE BODY IN AN ORACLE COMPATIBLE DATABASE. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 fails to do reinitialization of the package after
recompilation of the PL/SQL package body in an Oracle compatible
database
Package header / specification
=======================
CREATE OR REPLACE PACKAGE TEST_PKG
IS
PROCEDURE sp_test;
END TEST_PKG;
/
Package body
======================================
CREATE OR REPLACE PACKAGE BODY TEST_PKG
IS
-- Package variables
g_category VARCHAR2(20);
g_subcategory NUMBER;
PROCEDURE sp_test
IS
BEGIN
dbms_output.put_line('TEST_PKG sp_test g_category: '||
g_category);
dbms_output.put_line('TEST_PKG sp_test g_subcategory: '||
g_subcategory);
END sp_test;
-- Initialization block
BEGIN
g_category := 'TEST_PKG';
g_subcategory := 1;
dbms_output.put_line('TEST_PKG INIT BLOCK');
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line('error - '|| sqlerrm);
END TEST_PKG;
/
db2 -td/ -f initblockrecompiletest.pks
DB20000I The SQL command completed successfully.
db2 -td/ -f initblockrecompiletest.pkb
DB20000I The SQL command completed successfully.
db2 call TEST_PKG.sp_test
Return Status = 0
TEST_PKG INIT BLOCK
TEST_PKG sp_test g_category: TEST_PKG
TEST_PKG sp_test g_subcategory: 1
db2 -td/ -f initblockrecompiletest.pkb
DB20000I The SQL command completed successfully.
db2 call TEST_PKG.sp_test
Return Status = 0
TEST_PKG sp_test g_category:
TEST_PKG sp_test g_subcategory: |
| Problem Summary: |
****************************************************************
* 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: |
Disconnecting and reconnecting the current session will reset
the package state. |
| Solution |
Fixed in DB2 V10.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.07.2015
22.01.2016
22.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
