Oracle 12c DBMS_XMLTRANSLATIONS Demos

Oracle DBMS_XMLTRANSLATIONS Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. 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.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Translation so strings can be searched/displayed

AUTHID

CURRENT_USER

Dependencies

DBMS_XDBTRANS_LIB

XMLTYPE

Documented

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