|
Problem IT34440
|
Status: Closed |
ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
CREATE PROCEDURE may statement failed during compiling with
DB21034E error.
The following is a sample case.
$ db2 -td@ -vf sampsp.ddl
--- sampsp.ddl -----
CREATE TYPE TYP_PARAM_ARRAY AS VARCHAR(512) ARRAY[10]
DB20000I The SQL command completed successfully.
CREATE OR REPLACE PROCEDURE sampsp()
RETURNS INTEGER
LANGUAGE NZPLSQL AS
BEGIN_PROC
DECLARE
 C_RET_OK CONSTANT INTEGER := 0;
 ARR_MAIL_TO RECORD AS TYP_CMN_PARAM_ARRAY;
BEGIN
 ARR_MAIL_TO := ARRAY['...'];
 RETURN C_RET_OK;
END;
END_PROC
---------------------
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1131N A stored procedure process has been terminated
abnormally. Routine
name: "SYSIBMINTERNAL.SQLEXC_COMPILE_NPS". Specific name:
"SQLEXC_XCOMP_NPS1". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CREATE PROCEDURE may statement failed during compiling with *
* DB21034E error. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.0 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* CREATE PROCEDURE may statement failed during compiling with *
* DB21034E error. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.0 or higher *
**************************************************************** |
| Comment |
Upgrade to Db2 11.5.5.0 or higher |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.10.2020
20.11.2020
20.11.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
