Oracle DBMS_XMLTRANSLATIONS Demos

Oracle DBMS_XMLTRANSLATIONS Version 11.2.0.3

General Information

AUTHID

CURRENT_USER

Dependencies

DBMS_XDBTRANS_LIB

XMLTYPE

First Available

2006

Security Model

Owned by SYS 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