PL/SQL and Oracle data types not supported by Routine debugger

The following PL/SQL data types have limited or not support by Routine debugger (Routine debugger)

The following table show the PL/SQL and Oracle data types that are not supported by the Routine debugger, as well as the equivalent DB2® SQL data type. All other data types are supported for display and updated in the Routine debugger.

Table 1. PL/SQL data types not supported by Routine debugger
PL/SQL data type DB2 SQL data type Type of support
BLOB BLOB (4096) Display only.
BLOB(n) BLOB (n) n=1-2147483647 Display only. First 32K bytes only.
LONG RAW BLOB(32760) Display only.
NCLOB DBCLOB(2048) Display only.
NCLOB(n) DBCLOB(2000) Display only.
RAW BLOB(32767) RAW(n) BLOB n=1-32767 Display only.
CURSOR, SYS_REFCURSOR, REFCURSOR, REF CURSOR   Display only. Not supported for PL/SQL user-defined functions, are supported only for OUT parameters
XMLTYPE XML Not supported yet Not supported yet

The ROW and ARRAY (scalar array) local variables are supported in PL/SQL routines by the Routine debugger.

Additional limitations for PL/SQL routines

Table 2. Oracle data types not supported by Routine debugger
Oracle data type Type of support
BFILE (4) Not supported.
BLOB (4) Not supported.
BOOLEAN, PL/SQL BOOLEAN For display only.
CLOB (4) Not supported.
INTERVAL Not supported.
INTERVAL YEAR TO MONTH Not supported.
INTERVAL DAY TO SECOND Not supported.
LONG (5) Not supported.
NCHAR, NATIONAL CHARACTER, NATIONAL CHAR Cannot be displayed.
NCLOB (4) Does not display real value.
NVARCHAR2, NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING, NCHAR VARYING Not displayed.
NATURAL Not supported.
NATURALN Can be displayed and variables updated locally
POSITIVE Not supported by DB2
POSITIVEN Can be displayed and variables updated locally
SIMPLE_INTEGER Can be displayed and variables updated locally
TABLE Not supported.
UROWID Not supported.
VARRAY Not supported.
XMLTYPE Not supported.

Feedback