Oracle 12c DBMS_XMLTRANSLATIONS

Oracle DBMS_XMLTRANSLATIONS Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

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;

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;

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