Oracle | DBMS_XMLTRANSLATIONS

Oracle DBMS_XMLTRANSLATIONS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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