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