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