PL/SQL and Oracle data types not supported by the workbench

The following PL/SQL and Oracle data types are not supported by the workbench

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.

Table 1. PL/SQL and Oracle data types not supported by Data Studio
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  
Note: 1NATURALN, POSITIVEN, and SIMPLE_INTEGER are subtypes of PLS_INTEGER with a NOT NULL constraint. This prevents them from being used as OUT parameters. They are not listed for creating routine parameters, but you may use them as IN or IN OUT in the editor.

Feedback