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.
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
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. |