CLPPlus restrictions

The CLPPlus interface has certain connection, command, and statement restrictions.

The CLPPlus interface has the following restrictions on PL/SQL support:
  • PL/SQL functions and triggers cannot be created 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 DBCLOB data type.
  • The XMLTYPE data type is not supported.
  • TYPE declaration is not supported in a function, procedure, trigger, or anonymous block.
  • The FOR EACH STATEMENT option is not supported for PL/SQL triggers.

The EDIT command is supported in the CLPPlus window mode. The command is not supported in the CLPPlus non-window mode.