Development — PL/SQL, SQL, SQLJ

This section describes issues associated with PL/SQL, SQL, and SQLJ development.

PL/SQL Packages Not Accessible

The following PL/SQL packages are not accessible in Exadata Express:

  • APEX_INSTANCE_ADMIN

  • DBMS_CDC_PUBLISH

  • DBMS_CHANGE_NOTIFICATION

  • DBMS_CQ_NOTIFICATION

  • DBMS_DST

  • DBMS_MONITOR

  • DBMS_PDB

  • DBMS_PROPAGATION_ADM

  • DBMS_REPAIR

  • DBMS_SERVICE

  • DBMS_SPACE_ADMIN

  • DBMS_SYS_SQL

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL Package Ignores Container GUID

The DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL Pl/SQL package ignores CONTAINER_GUID. The CONTAINER_GUID parameter has been deprecated. However, the parameter is still supported for backward compatibility.

DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE and ALTER_TABLE_REFERENCEABLE Procedures Not Accessible

The DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE and ALTER_TABLE_REFERENCEABLE procedures are not accessible to CLOUDSERVICE user in the Cloud environment.

Object and OPAQUE Types Not Supported

Object and OPAQUE types are not supported and fail with ORA-00600: internal error code, arguments.