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 |