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.

• New Features

• Deprecated Features

• Desupported Features

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:

  • DBMS_DATA_MINING — Algorithm Settings: CUR Matrix Decomposition

  • DBMS_DATA_MINING — Algorithm Settings: Exponential Smoothing Models

  • DBMS_DATA_MINING — Algorithm Settings: Neural Network

  • DBMS_DATA_MINING — Algorithm Settings: Random Forest

  New solver settings ADMM and LBFGS are added. See DBMS_DATA_MINING — Solver Settings.

  The following procedures are new :

  • Create Model Using Registration Information

  • DROP_ALGORITHM Procedure

  • DROP_PARTITION Procedure

  • EXPORT_SERMODEL Procedure

  • FETCH_JSON_SCHEMA Procedure

  • IMPORT_SERMODEL Procedure

  • JSON Schema for R Extensible Algorithm

  • REGISTER_ALGORITHM Procedure

• 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.