Restrictions on PL/SQL support
It is important to note the restrictions on PL/SQL compilation support before performing PL/SQL compilation, or when troubleshooting PL/SQL compilation or runtime problems.
In this version:
- PL/SQL procedures, functions, triggers, and packages can only be created from the catalog partition in a partitioned database environment.
- The NCLOB data type is not supported for use in PL/SQL statements or in PL/SQL contexts when the database is not defined as a Unicode database. In Unicode databases, the NCLOB data type is mapped to a Db2® DBCLOB data type.
- The XMLTYPE data type is not supported.
- In a partitioned database environment, you cannot access cursor variables from remote nodes. You can only access cursor variables from the coordinator node.
- The use of nested type data types with PL/SQL package variables is not supported in autonomous routines.