DB2 - Problembeschreibung
Problem IC85563 | Status: Geschlossen |
ERROR SQL0206N OCCURS WHEN SQLERRM OUTSIDE THE EXCEPTION BLOCK WITHOUT PARAMETERS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Error SQL0206N "SYSIBMINTERNAL_SQLERRM" is not valid in the context where it is used. LINE NUMBER=11. SQLSTATE=42703 is returned when the customer is executing the SQLERRM outside the exception block WITHOUT PARAMETERS. Issue faced on DB2 Galileo 10.1 on Windows 2008 Issue can be reproduce by executing the below test case: ----------------------------------------------- CONNECT TO SAMPLE; SET SQLCOMPAT PLSQL; -- CREATE OR REPLACE PROCEDURE list_emp -- is DECLARE v_ErrorText varchar(2048); v_deptname varchar(100); -- SYSIBMINTERNAL_SQLERRM VARCHAR(500); BEGIN select deptname into v_deptname from org fetch first 1 row only; -- EXCEPTION -- WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; / ---------------------------------------------------- | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All user on Galileo version * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * NA * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.07.2012 31.10.2012 31.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.2 | |
10.5.0.2 |