Changes in This Release for Oracle Database PL/SQL Packages and Types Reference

This preface contains:

Changes in Oracle Database Release 18c, Version 18.1

Changes in Oracle Database Release 18c, Version 18.1

The following are changes in Oracle Database PL/SQL Packages and Types Reference for Oracle Database release 18c, version 18.1.

See Oracle Database New Features Guide for a complete list of new features in this release.

New Features

This section lists the major new features in Oracle Database release 18c version 18.1 PL/SQL Packages and Types Reference.

The following features are new in this release:

DBMS_DATA_MINING

New Mining function TIME_SERIES is added. See DBMS_DATA_MINING — Mining Functions.
The following model settings are new:
New solver settings ADMM and LBFGS are added. See DBMS_DATA_MINING — Solver Settings.
The following procedures are new :
DBMS_DATAPUMP

The Export operation under DATA_OPTIONS parameter of the SET_PARAMETER Procedure supports a new value KU$_DATAOPT_XMLTYPE_CLOB.
See SET_PARAMETER Procedures
DBMS_HPROF

The new CREATE_TABLES procedure allows you to create hierarchical profiler database tables and data structures in the user's session.

CREATE_TABLES Procedure
DBMS_INMEMORY_ADMIN

Two new procedures added to the DBMS_INMEMORY_ADMIN package.
See
- AIM_GET_PARAMETER Procedure
- AIM_SET_PARAMETER Procedure
DBMS_MEMOPTIMIZE

The new package DBMS_MEMOPTIMIZE provides an interface for managing data in the memoptimize pool.

See "DBMS_MEMOPTIMIZE"
DBMS_PDB

New procedures added to the DBMS_PDB package.

See EXPORTRMANBACKUP Procedure
DBMS_WORKLOAD_REPLAY

The LOAD_LONG_SQLTEXT procedure of the package DBMS_WORKLOAD_REPLAY loads the captured SQL statements that are longer than 1000 characters to the DBA_WORKLOAD_LONG_SQLTEXT view.
UTL_I18N

The new overloaded functions VALIDATE_CHARACTER_ENCODING of the package UTL_I18N validate the character encoding of VARCHAR2, NVARCHAR2, CLOB, and NCLOB data.

See "VALIDATE_CHARACTER_ENCODING Functions"
DBMS_SODA

The new package DBMS_SODA is a PL/SQL package implementing Simple Oracle Document Access (SODA) which allows you to use the Oracle Database as a NoSQL document store.

See "DBMS_SODA"
DBMS_TF

The new DBMS_TF package contains utilities for Polymorphic Table Functions (PTF) implementation.

See "DBMS_TF"
SODA Types

"SODA Types"

Deprecated Features

List of deprecated features in Oracle Database release 18c version 18.1 PL/SQL Packages and Types Reference.

The following features are deprecated in this release, and may be desupported in a future release:

Extended Datatype Support (EDS) is deprecated from the DBMS_LOGSTDBY package. All EDS-supported Oracle data types are now supported natively by logical standbys or Oracle GoldenGate.
Deprecation of the DBMS_LOCK.SLEEP Procedure.

Use DBMS_SESSION.SLEEP Procedure instead.
*GET_MODEL_DETAILS are deprecated and are replaced with Model Detail Views. See Summary of DBMS_DATA_MINING Subprograms for a list of deprecated functions and Deprecated Types for deprecated types. See Oracle Data Mining User’s Guidefor Model Detail Views and Oracle Database Reference for catalog views.
Deprecation of the DBMS_XMLQUERY package

Use DBMS_XMLGEN instead.
Deprecation of the DBMS_XMLSAVE package

Use DBMS_XMLSTORE instead.
Deprecation of these Oracle Multimedia packages and types:
- ORD_AUDIO
- ORD_DOC
- ORD_IMAGE
- ORD_VIDEO
- Oracle Multimedia ORDAudio
- Oracle Multimedia ORDDoc
- Oracle Multimedia ORDImage
- Oracle Multimedia ORDVideo
Use Oracle SecureFiles with third-party products for metadata extraction and for image processing and conversion instead of Oracle Multimedia.

Desupported Features

This section lists the desupported features in Oracle Database release 18c version 18.1 PL/SQL Packages and Types Reference.

The following features are desupported in this release:

The following subprograms are desupported from the DBMS_XDB package:
- ADDHTTPEXPIREMAPPING
- ADDMIMEMAPPING
- ADDSCHEMALOCMAPPING
- ADDSERVLETMAPPING
- ADDSERVLETSECROLE
- ADDXMLEXTENSION
- CFG_GET
- CFG_REFRESH
- CFG_UPDATE
- DELETEHTTPEXPIREMAPPING
- DELETEMIMEMAPPING
- DELETESCHEMALOCMAPPING
- DELETESERVLET
- DELETESERVLETMAPPING
- DELETESERVLETSECROLE
- DELETEXMLEXTENSION
- GETFTPPORT
- GETHTTPPORT
- GETLISTENERENDPOINT
- SETFTPPORT
- SETHTTPPORT
- SETLISTENERENDPOINT
- SETLISTENERLOCALACCESS
Use the subprograms available in package DBMS_XDB_CONFIG instead.
The following initialization parameter is desupported from the DBMS_LOGMNR_D package:
- UTL_FILE_DIR
Use a directory object instead.
The following constants are desupported from the DBMS_XDB package:
- XDB_ENDPOINT_HTTP
- XDB_ENDPOINT_HTTP2
- XDB_PROTOCOL_TCP
- XDB_PROTOCOL_TCPS
Use the constants available in package DBMS_XDB_CONFIG instead.
The following subprograms are desupported from the DBMS_XMLSCHEMA package:
- GENERATESCHEMA
- GENERATESCHEMAS
There are no replacements for these subprograms and there is no workaround for this change.
The DBMS_XMLTRANSLATIONS package is desupported. There are no replacements for these subprograms and there is no workaround for this change.