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.