The following table shows the PL/SQL and Oracle data types that are not supported. All other data types are supported for display and update.
| PL/SQL data types not support for DB2 by the workbench | Oracle PL/SQL data types not supported by the workbench |
|---|---|
| BOOLEAN (JCC does not support BOOLEAN for PL/SQL) | |
| INTERVAL | INTERVAL |
| INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
| INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND |
| NATURALN | NATURALN |
| POSITIVE | |
| POSITIVEN1 | POSITIVEN 1 |
| SIGNTYPE | |
| SIMPLE_INTEGER 1 | SIMPLE_INTEGER 1 |
| STRING | |
| TABLE | TABLE |
| TIMESTAMP WITH LOCAL TIME ZONE | |
| TIMESTAMP WITH TIME ZONE | |
| VARRAY | |
| XML, XMLTYPE |