Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Database Extensions User's GuideThe HCL OneDB™ Database Extensions User's Guide explains how to use the database extensions that come with HCL OneDB™: Large Object Locator, MQ messaging, binary data types, basic text search, node data type, HCL OneDB™ web feature service for Geospatial Data, and SQL packages.
SQL Packages ExtensionThe SQL packages extension provides SPL routines that you can use in an application that is compatible with database servers other than HCL OneDB™.

SQL Packages Extension

The SQL packages extension provides SPL routines that you can use in an application that is compatible with database servers other than HCL OneDB™.

The SQL packages extension is a built-in extension in the extend/excompat directory of your installation. You must manually register the extension using the instructions in the HCL OneDB DataBlade® Module Installation and Registration Guide.

The database that contains the SQL packages extension must meet the following requirements or the extension is not registered:

The database must be logged.
The database must not be defined as an ANSI database.

The following modules are included in the SQL packages extension:

DBMS_ALERT
DBMS_LOB
DBMS_OUTPUT
DBMS_RANDOM
UTL_FILE