Oracle | DBMS_XMLTRANSLATIONS

Oracle DBMS_XMLTRANSLATIONS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Translation so strings can be searched/displayed

AUTHID CURRENT_USER

Dependencies

DBMS_XDBTRANS_LIB

XMLTYPE

Documented No

First Available 2006

Security Model Owned by XDB with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsxtr.sql

Subprograms

DISABLETRANSLATION	GETBASEDOCUMENT	TRANSLATEXML
ENABLETRANSLATION	MERGEXLIFF	UPDATETRANSLATION
EXTRACTXLIFF	SETSOURCELANG

DISABLETRANSLATION

Disables translations in the current session so that query or retrieval will take place on the base document ignoring session language values dbms_xmltranslations.disableTranslation;

exec dbms_xmltranslations.disableTranslation;

      

      PL/SQL procedure successfully completed.

ENABLETRANSLATION

Enables translations in the current session so that query or retrieval will take place on the base document ignoring session language values dbms_xmltranslations.enableTranslation;

exec dbms_xmltranslations.enableTranslation;

      

      PL/SQL procedure successfully completed.

EXTRACTXLIFF

Extracts the translations in XLIFF format from either an XMLTYPE or a resource in the XDB Repository

Overload 1 dbms_xmltranslations.extractXLIFF( doc IN XMLTYPE, xpath IN VARCHAR2, namespace IN VARCHAR2 := NULL) RETURN XMLTYPE;

TBD

Overload 2 dbms_xmltranslations.extractXLIFF( abspath IN VARCHAR2, xpath IN VARCHAR2, namespace IN VARCHAR2 := NULL) RETURN XMLTYPE;

TBD

GETBASEDOCUMENT

Returns the base document with translations dbms_xmltranslations.getBaseDocument(doc IN XMLTYPE) RETURN XMLTYPE;

TBD

MERGEXLIFF

Merges the translations in XLIFF format into either an XMLTYPE or a resource in the XDB Repository
Overload 1 dbms_xmltranslations.mergeXLIFF( doc IN XMLTYPE, xliff IN XMLTYPE) RETURN XMLTYPE;

TBD

Overload 2 dbms_xmltranslations.mergeXLIFF(xliff IN XMLTYPE);

TBD

SETSOURCELANG

Sets the source language at a specified XPATH dbms_xmltranslations.setSourceLang( doc IN XMLTYPE, xpath IN VARCHAR2, lang IN VARCHAR2, namespace IN VARCHAR2 := NULL) RETURN XMLTYPE;

TBD

TRANSLATEXML

Returns the document in the specified language dbms_xmltranslations.translateXML( doc IN XMLTYPE, lang IN VARCHAR2) RETURN XMLTYPE;

TBD

UPDATETRANSLATION

Updates the translation in a particular language at the specified XPATH dbms_xmltranslations.updateTranslation( doc IN XMLTYPE, xpath IN VARCHAR2, lang IN VARCHAR2, value IN VARCHAR2, namespace IN VARCHAR2 := NULL) RETURN XMLTYPE;

TBD