Oracle UTL_XML Version 21c |
---|
General Information | ||||||||||||||||
Library Note |
|
|||||||||||||||
Purpose | PL/SQL wrapper over COREs C-based XML/XSL processor. | |||||||||||||||
Note | This is the package header for the PL/SQL interface to CORE's C-based XML Parser and XSL Processor. It currently does not provide an interface to CORE's C-based DOM, SAX and Namespace APIs. You MUST call function XMLINIT before any others in this package. Pkg. body and trusted lib. implementations are in: /vobs/rdbms/src/server/datapump/ddl. | |||||||||||||||
AUTHID | DEFINER | |||||||||||||||
Constants |
|
|||||||||||||||
Data Types | Data Type (Opaque Handles) |
|||||||||||||||
Dependencies |
|
|||||||||||||||
Documented | No | |||||||||||||||
First Available | 9.0.1 | |||||||||||||||
Security Model | Owned by SYS with no privileges granted. Direct access to this package is prevented by means of an Accessible By clause. |
|||||||||||||||
Source | {ORACLE_HOME}/rdbms/admin/utlcxml.sql | |||||||||||||||
Subprograms |
|
|||||||||||||||
COMPARE | ||||||||||||||||
Compares the DDL of 2 input objects and returns a diff document | utl_xml.compare( |
|||||||||||||||
TBD | ||||||||||||||||
GETDDLSRCFROMXML | ||||||||||||||||
Bypass XSL processing for retrieval of PL/SQL source from source$ Generating DDL for very large pkgs via XSL can be very expensive. This routine forms the heart of an alternate fast method of retrieving the source of an object via C string manipulations rather than XSL transformation. |
utl_xml.getDDLSrcFromXML( |
|||||||||||||||
DECLARE |
||||||||||||||||
GETFDO | ||||||||||||||||
Return the format descriptor object for objects on this platform | utl_xml.getFdo RETURN RAW; |
|||||||||||||||
SELECT utl_xml.getFdo FROM dual; |
||||||||||||||||
GETHASHCODE | ||||||||||||||||
Upgrading from 8.1.7 corrupts the hashcode in type$, so this functions calls kotgHashCode | utl_xml.gethashcode( |
|||||||||||||||
set serveroutput on |
||||||||||||||||
GETNEXTTYPEID | ||||||||||||||||
Given the current value of next_typeid for a type hierarchy and another typeid, see if next_typeid needs to be incremented, and, if so, what its new value should be | utl_xml.getnexttypeid( |
|||||||||||||||
TBD | ||||||||||||||||
HASTSTZ | ||||||||||||||||
Returns TRUE if the type have a TSTZ element or attribute | utl_xml.HasTsTz( |
|||||||||||||||
TBD | ||||||||||||||||
ISNAMEOMF | ||||||||||||||||
Tests a file name to see if it is an OMF name 0 = not OMF 1 = OMF |
utl_xml.isnameomf( |
|||||||||||||||
No demo possible as this procedure is protected with an ACCESSIBLE BY clause pointing to dbms_metadata_util |
||||||||||||||||
LONG2CLOB | ||||||||||||||||
Fetch a LONG as a CLOB NOTE: the doc states that tab and col must belong to a short list of valid values, see prvtcxml.sql, but this file does not exist in the distribution |
utl_xml.long2clob( |
|||||||||||||||
CREATE TABLE t1 (x INT, y LONG); |
||||||||||||||||
PARSEEXPR | ||||||||||||||||
Parse an expression (boolean or arithmetic) and return in a CLOB as XML | utl_xml.parseexpr( |
|||||||||||||||
No demo possible as this procedure is protected with an ACCESSIBLE BY clause pointing to dbms_metadata |
||||||||||||||||
PARSEQUERY | ||||||||||||||||
Parse a SQL query and return in a CLOB as XML | utl_xml.parsequery( |
|||||||||||||||
No demo possible as this procedure is protected with an ACCESSIBLE BY clause pointing to dbms_metadata |
||||||||||||||||
SETXMLTRANSFORMENGINE | ||||||||||||||||
Sets the transformation engine to either XmlXvm or LPX. If TRUE , then XmlXvm otherwise Lpx. | utl_xml.setXmlTransformEngine(use_xmlxvm_engine IN BOOLEAN); |
|||||||||||||||
exec utl_xml.setXmlTransformEngine(TRUE); |
||||||||||||||||
SSCFIND | ||||||||||||||||
Find stylesheet by index or name or allocate it | utl_xml.sscfind( |
|||||||||||||||
TBD | ||||||||||||||||
SSCGETCTX | ||||||||||||||||
Get xml context identifier for the specified stylesheet | utl_xml.sscGetCtx(ss_index IN BINARY_INTEGER) |
|||||||||||||||
TBD | ||||||||||||||||
SSCMINIMIZECACHE | ||||||||||||||||
Minimize stylesheet cache LRU size (set to 1) | utl_xml.sscMinimizeCache; |
|||||||||||||||
exec utl_xml.sscMinimizeCache; |
||||||||||||||||
SSCPARSE | ||||||||||||||||
Sets the top-level style sheet for the upcoming transform and also establishes the base URI for any included or imported stylesheets | utl_xml.sscParse( |
|||||||||||||||
No demo possible as this procedure is protected with an ACCESSIBLE BY clause pointing to dbms_metadata_int |
||||||||||||||||
SSCPURGE | ||||||||||||||||
Purge the stylesheet cache | utl_xml.sscPurge; |
|||||||||||||||
exec utl_xml.sscPurge; |
||||||||||||||||
SSCSETDEBUG | ||||||||||||||||
Set stylesheet cache's debug level to match prvtmeti.sql | utl_xml.sscSetDebug(value IN BOOLEAN); |
|||||||||||||||
exec utl_xml.sscSetDebug(FALSE); |
||||||||||||||||
TYPEHASHCODEEQ | ||||||||||||||||
Does the hashcode match the hc for the type? The type hashcode versions changed between 10.2 and 11g so a simple compare doesn't work. This is a wrapper around kottyphcequ | utl_xml.typehashcodeeq( |
|||||||||||||||
TBD | ||||||||||||||||
WINDOWS32 | ||||||||||||||||
Determines if Oracle is running on a 32bit Windows NT system | utl_xml.windows32(flag OUT BINARY_INTEGER); |
|||||||||||||||
set serveroutput on |
||||||||||||||||
XMLCLEAN | ||||||||||||||||
Cleans up memory from last doc. associated with this parser | utl_xml.xmlclean(ctx IN xmlCtx); |
|||||||||||||||
TBD | ||||||||||||||||
XMLDUMPCTXS | ||||||||||||||||
Dump info on the active XML contexts to the trace file | utl_xml.xmlDumpCtxs; |
|||||||||||||||
exec utl_xml.xmlDumpCtxs; |
||||||||||||||||
XMLINIT | ||||||||||||||||
Initializes a DOM XML parser | utl_xml.xmlInit RETURN xmlCtx; |
|||||||||||||||
DECLARE |
||||||||||||||||
XMLPARSE | ||||||||||||||||
Parses target of a URI (file or DB column) into a DOM format Overload 1 |
utl_xml.xmlparse( |
|||||||||||||||
No demo possible as this procedure is protected with an ACCESSIBLE BY clause pointing to dbms_metadata_int |
||||||||||||||||
Parses the CLOB source doc into a DOM format Overload 2 |
utl_xml.xmlparse( |
|||||||||||||||
This overload is not protected with an ACCESSIBLE BY clause |
||||||||||||||||
XMLSETMEMDEBUG | ||||||||||||||||
Sets kux's Lpx memory tracing | utl_xml.xmlSetMemDebug(value IN BOOLEAN); |
|||||||||||||||
exec utl_xml.xmlSetMemDebug (FALSE); |
||||||||||||||||
XMLSETPARSEFLAG | ||||||||||||||||
Sets parsing options for this parser These are sticky across parses using the same parser. |
utl_xml.xmlsetparseflag( |
|||||||||||||||
TBD | ||||||||||||||||
XSLLOADFROMFILE | ||||||||||||||||
Load an XSL stylesheet from a BFILE into a CLOB | utl_xml.xslloadfromfile( |
|||||||||||||||
TBD | ||||||||||||||||
XSLRESETPARAMS | ||||||||||||||||
Resets all parameters to their default values for the given XSL parser ctx | utl_xml.xslresetparams(xslCtx IN xmlCtx); |
|||||||||||||||
TBD | ||||||||||||||||
XSLSETPARAM | ||||||||||||||||
set a parameter value for a stylesheet | utl_xml.xslsetparam( |
|||||||||||||||
TBD | ||||||||||||||||
XSLTRANSFORM | ||||||||||||||||
Transforms srcdoc into resdoc using the XSL stylesheet associated with xslCtx | utl_xml.xsltransform( |
|||||||||||||||
TBD | ||||||||||||||||
XSLTRANSFORMCTOX | ||||||||||||||||
Transform a Clob to xmlCtx | utl_xml.xxltransformctox( |
|||||||||||||||
TBD | ||||||||||||||||
XSLTRANSFORMXTOC | ||||||||||||||||
Perform an XSL transformation on a pre-parsed xmlctx returning a CLOBU | utl_xml.xxltransformxtoc( |
|||||||||||||||
TBD | ||||||||||||||||
XSLTRANSFORMXTOX | ||||||||||||||||
Transforms a pre-parsed xmlCtx returning another xmlCtx | utl_xml.xsltransformxtox( |
|||||||||||||||
TBD |
Related Topics |
Built-in Functions |
Built-in Packages |
DBMS_LOB |
LONG to CLOB |
What's New In 21c |
What's New In 23c |
This site is maintained by Dan Morgan. Last Updated: | This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved | |||||||||
|
||||||||||