Changes in This Release

This is a summary of important changes in Oracle XML Developer's Kit Programmer's Guide.

Desupported Feature

The following is the desupported feature in Oracle XML Developer's Kit Programmer's Guide for Oracle Database Release 23ai.

Desupport of Oracle Database Extensions for .NET

Oracle Database Extensions for .NET is a feature of Oracle Database on Microsoft Windows that enables you to use stored procedures and functions written in a language managed by .NET, such as C#.

Oracle Database hosts the Microsoft Common Language Runtime (CLR) in an external process, outside of the Oracle Database process. Application developers can write stored procedures and functions using any .NET compliant language, such as C# and VB.NET, and use these .NET stored procedures in the database, in the same manner as other PL/SQL or Java stored procedures. .NET stored procedures can be called from PL/SQL packages, procedures, functions, and triggers; from SQL statements; or from anywhere a PL/SQL procedure or function can be called.

Migration options include:
  • Moving the .NET code (assemblies) into a middle tier
  • Using the External Procedures feature to have the external process load and execute the .NET assembly
  • Rewriting the stored procedures using PL/SQL or Java

Deprecated Features

This section lists the deprecated features in XML Developer's Kit Programmer's Guide for Oracle Database Release 23ai.

Oracle recommends that you do not use deprecated features/values in new applications. Support for deprecated features is for backward compatibility only.

Deprecation of XML DB Repository

The Oracle XML DB Repository is deprecated with Oracle Database 23ai.

Oracle recommends that you replace any functionality used in XML DB Repository with alternative technologies.

Deprecation of DBMS_XMLGEN PL/SQL Package

The PL/SQL package DBMS_XMLGEN is deprecated in Oracle Database 23ai.

DBMS_XMLGEN is a non-standard Oracle-proprietary package that is provided to generate and convert XML documents from SQL queries or with PL/SQL. This package is deprecated, and can be desupported in a future release. Oracle recommends that you use SQL/XML operators to generate XML from relational columns instead. Using ANSI SQL/XML operators for any generation and modification of XML documents provides a standardized and future-proof way to work with XML documents.

Deprecation of Unstructured XML Indexes

Unstructured XML indexes are deprecated in Oracle Database 23ai.

Unstructured XML indexes are deprecated and superseded by XML search indexes. Oracle recommends that you use XML search indexes or structured XML indexes.