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
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.
-
DBMS_DATAPUMP
The
Export
operation underDATA_OPTIONS
parameter of theSET_PARAMETER Procedure
supports a new valueKU$_DATAOPT_XMLTYPE_CLOB
. -
DBMS_HPROF
The new
CREATE_TABLES
procedure allows you to create hierarchical profiler database tables and data structures in the user's session. -
DBMS_INMEMORY_ADMIN
Two new procedures added to the
DBMS_INMEMORY_ADMIN
package. -
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.
-
DBMS_WORKLOAD_REPLAY
The
LOAD_LONG_SQLTEXT
procedure of the packageDBMS_WORKLOAD_REPLAY
loads the captured SQL statements that are longer than 1000 characters to theDBA_WORKLOAD_LONG_SQLTEXT
view. -
UTL_I18N
The new overloaded functions
VALIDATE_CHARACTER_ENCODING
of the packageUTL_I18N
validate the character encoding of VARCHAR2, NVARCHAR2, CLOB, and NCLOB data. -
DBMS_SODA
The new package
DBMS_SODA
is aPL/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
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
packageUse
DBMS_XMLGEN
instead. -
Deprecation of the
DBMS_XMLSAVE
packageUse
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.