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.
DB2 Version 10.1 for Linux, UNIX, and Windows