XML SQL Utility (XSU) PL/SQL API


XSU’s PL/SQL API consists of two packages:

DBMS_XMLQuery

Types:

ctxType
The type of the query context handle. This the return type of "DBMS_ XMLQuery.newContext()".

Constants:

DEFAULT_ROWSETTAG
The tag name for the element enclosing the XML generated from the result set (i.e. for most cases the root node tag name) -- ROWSET
DEFAULT_ERRORTAG
The default tag to enclose raised errors -- ERROR.
DEFAULT_ROWIDATTR
The default name for the cardinality attribute of XML elements coresponding to db. records. -- NUM
DEFAULT_ROWTAG
The default tag name for the element cooresponding to db. records. -- ROW
 
DEFAULT_DATE_FORMAT
Default date mask. -- ’MM/dd/yyyy HH:mm:ss’
ALL_ROWS   
The ALL_ROWS parameter is to indicate that all rows are needed in the output.
NONE        
Used to specifies that the output should not contain any XML metadata (e.g. no DTD).
DTD        
Used to specify that the generation of the DTD is desired.
SCHEMA        
Used to specify that the generation of the XML SCHEMAis desired.
LOWER_CASE        
Use lower cased tag names.
UPPER_CASE
Use upper case tag names.
 

Function and Procedure Index:

 o PROCEDURE closeContext(ctxType)
It closes/deallocates a particular query context
 o FUNCTION getDTD(ctxType, BOOLEAN := false) RETURN CLOB
Generates the DTD based on the SQL query used to init.
 
 o PROCEDURE getDTD(ctxType, CLOB, BOOLEAN := false)
Generates the DTD based on the SQL query used to init.
 o PROCEDURE getExceptionContent(ctxType, NUMBER, VARCHAR2)
Via its arguments, this method returns the thrown exception's error code and error message (i.e.
 o FUNCTION getXML(VARCHAR2, NUMBER := NONE) RETURN CLOB
Generates the XML doc.
 o FUNCTION getXML(CLOB, NUMBER := NONE) RETURN CLOB
Generates the XML doc.
 o FUNCTION getXML(ctxType, NUMBER := NONE) RETURN CLOB
Generates the XML doc.
 o PROCEDURE getXML(ctxType, CLOB, NUMBER := NONE)
Generates the XML doc.
 o FUNCTION newContext(VARCHAR2) RETURN ctxType
It creates a query context, and it returns the context handle.
 o FUNCTION newContext(CLOB) RETURN ctxType
It creates a query context, and it returns the context handle.
 o PROCEDURE propagateOriginalException(ctxType, BOOLEAN)
Tells the XSU that if an exception is raised, and is being thrown, the XSU should throw the very exception raised; rather then, wrapping it with an OracleXMLSQLException.
 o PROCEDURE setBindValue(ctxType, VARCHAR2, VARCHAR2)
Sets a value for a particular bind name.
 o PROCEDURE setCollIdAttrName(ctxType, VARCHAR2
Sets the name of the id attribute of the collection element's separator tag.
 o PROCEDURE setDataHeader(ctxType, CLOB := null, VARCHAR2 := null)
Sets the xml data header.
 o PROCEDURE setDateFormat(ctxType, VARCHAR2)
Sets the format of the generated dates in the XML doc.
 o PROCEDURE setErrorTag(ctxType, VARCHAR2)
Sets the tag to be used to enclose the xml error docs.
 o PROCEDURE setMaxRows (ctxType, NUMBER)
Sets the max number of rows to be converted to XML.
 o PROCEDURE setMetaHeader(ctxType, CLOB := null)
Sets the XML meta header.
 o PROCEDURE setRaiseException(ctxType, BOOLEAN)
Tells the XSU to throw the raised exceptions.
 o PROCEDURE setRaiseNoRowsException(ctxType, BOOLEAN)
Tells the XSU to throw or not to throw an OracleXMLNoRowsException in the case when for one reason or another, the XML doc generated is empty.
 o PROCEDURE setRowIdAttrName(ctxType, VARCHAR2)
Sets the name of the id attribute of the row enclosing tag.
 o PROCEDURE setRowIdAttrValue(ctxType, VARCHAR2)
Specifies the scalar column whose value is to be assigned to the id attribute of the row enclosing tag.
 o PROCEDURE setRowsetTag(ctxType, VARCHAR2)
Sets the tag to be used to enclose the xml dataset.
 o PROCEDURE setRowTag(ctxType, VARCHAR2)
Sets the tag to be used to enclose the xml element corresponding to a db.
 o PROCEDURE setSkipRows(ctxType, NUMBER)
Sets the number of rows to skip.
 o PROCEDURE setStylesheetHeader(ctxType, VARCHAR2, VARCHAR2 := 'text/xsl')
Sets the stylesheet header (i.e.
 o PROCEDURE setTagCase(ctxType, NUMBER)
Specified the case of the generated XML tags.
 o PROCEDURE setXSLT(ctxType, VARCHAR2, VARCHAR2 := null)
Registers a stylesheet to be applied to generated XML.
 o PROCEDURE setXSLT(ctxType, CLOB, VARCHAR2 := null)
Registers a stylesheet to be applied to generated XML.
 o PROCEDURE setXSLTParam(ctxType, VARCHAR2, VARCHAR2)
Sets the value of a top-level stylesheet parameter.
 o PROCEDURE removeXSLTParam(ctxType, VARCHAR2)
Removes a particular top-level stylesheet parameter.
 o PROCEDURE useNullAttributeIndicator(ctxType, BOOLEAN)
Specified weather to use an XML attribute to indicate NULLness, or to do it by omitting the inclusion of the particular entity in the XML document.

Functions and Procedures:

 o newContext

FUNCTION newContext(sqlQuery IN VARCHAR2) RETURN ctxType
It creates a query context, and it returns the context handle.

Parameters:
sqlQuery - SQL query, the results of which to convert to XML
Returns:
The context handle.
 o newContext
FUNCTION newContext(sqlQuery IN CLOB) RETURN ctxType
It creates a query context, and it returns the context handle.

Parameters:
sqlQuery - SQL query, the results of which to convert to XML
Returns:
The context handle.
 o closeContext
PROCEDURE closeContext(ctxHdl IN ctxType)
It closes/deallocates a particular query context

Parameters:
ctxHdl - context handle
 o setRowsetTag
PROCEDURE setRowsetTag(ctxHdl IN ctxType, tag IN VARCHAR2)
Sets the tag to be used to enclose the xml dataset.

Parameters:
ctxHdl - context handle
tag - tag name
 o setRowTag
PROCEDURE setRowTag(ctxHdl IN ctxType, tag IN VARCHAR2)
Sets the tag to be used to enclose the xml element corresponding to a db. record.

Parameters:
ctxHdl - context handle
tag - tag name
 o setErrorTag
PROCEDURE setErrorTag(ctxHdl IN ctxType, tag IN VARCHAR2)
Sets the tag to be used to enclose the xml error docs.

Parameters:
ctxHdl - context handle
tag - tag name
 o setRowIdAttrName
PROCEDURE setRowIdAttrName(ctxHdl IN ctxType, attrName IN VARCHAR2)
Sets the name of the id attribute of the row enclosing tag. Passing null or an empty string for the tag results the row id attribute to be omitted.

Parameters:
ctxHdl - context handle
attrName - attribute name
 o setRowIdAttrValue
PROCEDURE setRowIdAttrValue(ctxHdl IN ctxType, colName IN VARCHAR2)
Specifies the scalar column whose value is to be assigned to the id attribute of the row enclosing tag. Passing null or an empty string for the colName results the row id attribute being assigned the row count value (i.e. 0, 1, 2 and so on).

Parameters:
ctxHdl - context handle
colName - column whose value is to be assigned to the row id attr
 o setCollIdAttrName
PROCEDURE setCollIdAttrName(ctxHdl IN ctxType, attrName IN VARCHAR2)
Sets the name of the id attribute of the collection element's separator tag. Passing null or an empty string for the tag results the row id attribute to be omitted.

Parameters:
ctxHdl - context handle
attrName - attribute name
 o useNullAttributeIndicator
PROCEDURE useNullAttributeIndicator(ctxHdl IN ctxType, flag IN BOOLEAN)
Specified weather to use an XML attribute to indicate NULLness, or to do it by omitting the inclusion of the particular entity in the XML document.

Parameters:
ctxHdl - context handle
flag - use attribute to indicate null?
 o setTagCase
PROCEDURE setTagCase(ctxHdl IN ctxType, tCase IN NUMBER)
Specified the case of the generated XML tags.

Parameters:
ctxHdl - context handle
tCase - the tag's case (0-asAre, 1-lower, 2-upper)
 o setDateFormat
PROCEDURE setDateFormat(ctxHdl IN ctxType, mask IN VARCHAR2)
Sets the format of the generated dates in the XML doc. The syntax of the date format patern (i.e. the date mask), should conform to the requirements of the java.text.SimpleDateFormat class. Setting the mask to null or an empty string, results the use of the default mask -- DEFAULT_DATE_FORMAT.

Parameters:
ctxHdl - context handle
mask - the date mask
 o setMaxRows
PROCEDURE setMaxRows (ctxHdl IN ctxType, rows IN NUMBER)
Sets the max number of rows to be converted to XML. By default there is no max set.

Parameters:
ctxHdl - context handle
rows - max number of rows to generate
 o setSkipRows
PROCEDURE setSkipRows(ctxHdl IN ctxType, rows IN NUMBER)
Sets the number of rows to skip. By default 0 rows are skipped.

Parameters:
ctxHdl - context handle
rows - number of rows to skip
 o setStylesheetHeader
PROCEDURE setStylesheetHeader(ctxHdl IN ctxType, uri IN VARCHAR2, type IN VARCHAR2 := 'text/xsl')
Sets the stylesheet header (i.e. stylesheet processing instructions) in the generated XML doc. Note: Passing null for the uri argument will unset the stylesheet header and the stylesheet type.

Parameters:
ctxHdl - context handle
uri - stylesheet URI
type - stylesheet type; defaults to 'text/xsl'
 o setXSLT
PROCEDURE setXSLT(ctxHdl IN ctxType, uri IN VARCHAR2, ref IN VARCHAR2 := null)
Registers a stylesheet to be applied to generated XML. If a stylesheet was already registered, it gets replaced by the new one. To un-register the stylesheet pass in a null for the uri argument.

Parameters:
ctxHdl - context handle
uri - stylesheet URI
ref - URL for include, import and external entities
 o setXSLT
PROCEDURE setXSLT(ctxHdl IN ctxType, stylesheet CLOB, ref IN VARCHAR2 := null)
Registers a stylesheet to be applied to generated XML. If a stylesheet was already registered, it gets replaced by the new one. To un-register the stylesheet pass in a null or an empty string for the stylesheet argument.

Parameters:
ctxHdl - context handle
stylesheet - the stylesheet
ref - URL for include, import and external entities
 o setXSLTParam
PROCEDURE setXSLTParam(ctxHdl IN ctxType, name IN VARCHAR2, value IN VARCHAR2)
Sets the value of a top-level stylesheet parameter. The parameter value is expected to be a valid XPath expression (note that string literal values would therefore have to be explicitly quoted). NOTE: if no stylesheet is registered, this method is a no op.

Parameters:
ctxHdl - context handle
name - name of the top level stylesheet parameter
value - value to be assigned to the stylesheet parameter
 o removeXSLTParam
PROCEDURE removeXSLTParam(ctxHdl IN ctxType, name IN VARCHAR2, value IN VARCHAR2)
Sets the value of a top-level stylesheet parameter. The parameter value is expected to be a valid XPath expression (note that string literal values would therefore have to be explicitly quoted). NOTE: if no stylesheet is registered, this method is a no op.

Parameters:
ctxHdl - context handle
name - name of the top level stylesheet parameter
.
 o setBindValue
PROCEDURE setBindValue(ctxHdl IN ctxType, bindName IN VARCHAR2, bindValue IN VARCHAR2)
Sets a value for a particular bind name.

Parameters:
ctxHdl - context handle
bindName - bind name
bindValue - bind value
 o setMetaHeader
PROCEDURE setMetaHeader(ctxHdl IN ctxType, header IN CLOB := null)
Sets the XML meta header. When set, the header is inserted at the begining of the metadata part (DTD or XMLSchema) of each XML document generated by this object. Note that the last meta header specified is the one that is used; furthermore, passing in null for the header, parameter unsets the meta header.

Parameters:
ctxHdl - context handle
header - header
 o setDataHeader
PROCEDURE setDataHeader(ctxHdl IN ctxType, header IN CLOB := null, tag IN VARCHAR2 := null)
Sets the xml data header. The data header is an XML entity which is appended at the begining of the query-generated xml entity (ie. rowset). The two entities are enclosed by the tag specified via the docTag argument. Note that the last data header specified is the one that is used; furthermore, passing in null for the header, parameter unsets the data header.

Parameters:
ctxHdl - context handle
header - header
tag - tag used to enclose the data header and the rowset
 o setRaiseException
PROCEDURE setRaiseException(ctxHdl IN ctxType, flag IN BOOLEAN)
Tells the XSU to throw the raised exceptions. If this call isn't made or if false is passed to the flag argument, the XSU catches the SQL exceptions and generates an XML doc out of the exception's message.

Parameters:
ctxHdl - context handle
flag - throw raised exceptions?
 o setRaiseNoRowsException
PROCEDURE setRaiseNoRowsException(ctxHdl IN ctxType, flag IN BOOLEAN)
Tells the XSU to throw or not to throw an OracleXMLNoRowsException in the case when for one reason or another, the XML doc generated is empty. By default, the exception is not thrown.

Parameters:
ctxHdl - context handle
flag - throw OracleXMLNoRowsException if no data?
 o propagateOriginalException
PROCEDURE propagateOriginalException(ctxHdl IN ctxType, flag IN BOOLEAN)
Tells the XSU that if an exception is raised, and is being thrown, the XSU should throw the very exception raised; rather then, wrapping it with an OracleXMLSQLException.

Parameters:
ctxHdl - context handle
flag - propagate original exception?
 o getExceptionContent
PROCEDURE getExceptionContent(ctxHdl IN ctxType, errNo OUT NUMBER, errMsg OUT VARCHAR2)
Via its arguments, this method returns the thrown exception's error code and error message (i.e. sql error code) This is to get around the fact that the jvm throws an exception on top of whatever exception was raised; thus, rendering pl/sql unable to access the original exception.

Parameters:
ctxHdl - context handle
errNo - error number
errMsg - error message
 o getDTD
FUNCTION  getDTD(ctxHdl IN ctxType, withVer IN BOOLEAN := false) RETURN CLOB
Generates the DTD based on the SQL query used to init. the context.

Parameters:
ctxHdl - context handle
 
withVer - generate the version info?
Returns:
The DTD.
 o getDTD
PROCEDURE getDTD(ctx IN ctxType, xDoc IN CLOB, withVer IN BOOLEAN := false)
Generates the DTD based on the SQL query used to init. the context.

Parameters:
ctxHdl - context handle
xDoc - lob into which to write the generated XML doc
withVer - generate the version info?
 o getXML
FUNCTION  getXML(sqlQuery IN VARCHAR2, metaType IN NUMBER := NONE) RETURN CLOB
This is a convenience function. One doesn't have to explicitly open a context and close the context. This function creates the new context, executes the query, gets the xml back and closes the context..

Parameters:
sqlQueryl - SQL query
 
metaType - xml metadata type (i.e. NONE, DTD, SCHEMA)
Returns:
The XML document.

 o getXML

FUNCTION getXML(sqlQuery IN CLOB, metaType IN NUMBER := NONE) RETURN CLOB
 
This is a convenience function. One doesn't have to explicitly open a context and close the context. This function creates the new context, executes the query, gets the xml back and closes the context..

Parameters:
sqlQueryl - SQL query
 
metaType - xml metadata type (i.e. NONE, DTD, SCHEMA)
Returns:
The XML document.

 o getXML
FUNCTION  getXML(ctxHdl IN ctxType, metaType IN NUMBER := NONE) RETURN CLOB
Generates the XML doc. based on the SQL query used to init. the context.

Parameters:
ctxHdl - context handle
 
metaType - xml metadata type (i.e. NONE, DTD, SCHEMA)
Returns:
The XML document.

 o getXML

PROCEDURE getXML(ctxHdl IN ctxType, xDoc IN CLOB, metaType IN NUMBER := NONE)
Generates the XML doc. based on the SQL query used to init. the context.

Parameters:
ctxHdl - context handle
xDoc - lob into which to write the generated XML doc
metaType - xml metadata type (i.e. NONE, DTD, SCHEMA)

 

DBMS_XMLSave

Types:

ctxType
The type of the query context handle. This the return type of "DBMS_ XMLSave.newContext()".

Constants:

DEFAULT_ROWTAG
The default tag name for the element cooresponding to db. records. -- ROW
DEFAULT_DATE_FORMAT
Default date mask. -- ’MM/dd/yyyy HH:mm:ss’
MATCH_CASE        
Used to specify that when mapping XML elements to DB. entities the XSU should be case sensitive.
IGNORE_CASE
Used to specify that when mapping XML elements to DB. entities the XSU should be case insensitive.

Function and Procedure Index:

 o PROCEDURE clearKeyColumnList(ctxType)
Clears the key column list.
 o PROCEDURE clearUpdateColumnList(ctxType)
Clears the update column list.
 o PROCEDURE closeContext(ctxType)
It closes/deallocates a particular save context
 o FUNCTION deleteXML(ctxType, CLOB) RETURN NUMBER
Deletes records specified by data from the XML document, from the table specified at the context creation time.
 o FUNCTION deleteXML(ctxType, VARCHAR2) RETURN NUMBER
Deletes records specified by data from the XML document, from the table specified at the context creation time.
 o PROCEDURE getExceptionContent(ctxType, NUMBER, VARCHAR2)
Via its arguments, this method returns the thrown exception's error code and error message (i.e.
 o FUNCTION insertXML(ctxType, CLOB) RETURN NUMBER
Inserts the XML document into the table specified at the context creation time.
 o FUNCTION insertXML(ctxType, VARCHAR2) RETURN NUMBER
Inserts the XML document into the table specified at the context creation time.
 o FUNCTION newContext(targetTable IN VARCHAR2) RETURN ctxType
It creates a save context, and it returns the context handle.
 o PROCEDURE propagateOriginalException(ctxType, BOOLEAN)
Tells the XSU that if an exception is raised, and is being thrown, the XSU should throw the very exception raised; rather then, wrapping it with an OracleXMLSQLException.
 o PROCEDURE setBatchSize(ctxType, NUMBER)
Changes the batch size used during DML operations.
 o PROCEDURE setCommitBatch(ctxType, NUMBER)
Sets the commit batch size.
 o PROCEDURE setDateFormat(ctxType, VARCHAR2)
Describes to the XSU the format of the dates in the XML document.
 o PROCEDURE setIgnoreCase(ctxType, NUMBER)
The XSU does mapping of XML elements to db.
 o PROCEDURE setKeyColumn(ctxType, VARCHAR2)
This methods adds a column to the "key column list".
 o PROCEDURE setRowTag(ctxType, VARCHAR2)
Names the tag used in the XML doc., to enclose the XML elements corresponding to db.
 o PROCEDURE setUpdateColumn(ctxType, VARCHAR2)
Adds a column to the "update column list".
 o PROCEDURE getExceptionContent(ctxType, NUMBER, VARCHAR2)
Updates the table specified at the context creation time with data from the XML document.
 o PROCEDURE propagateOriginalException(ctxType, BOOLEAN)
Updates the table specified at the context creation time with data from the XML document.

Functions and Procedures:

 o newContext
 FUNCTION newContext(targetTable IN VARCHAR2) RETURN ctxType
It creates a save context, and it returns the context handle.

Parameters:
targetTable - the target table into which to load the XML doc
Returns:
The context handle.
 o closeContext
 PROCEDURE closeContext(ctxHdl IN ctxType)
It closes/deallocates a particular save context

Parameters:
ctxHdl - context handle
 o setRowTag
 PROCEDURE setRowTag(ctxHdl IN ctxType, tag IN VARCHAR2)
Names the tag used in the XML doc., to enclose the XML elements corresponding to db. records.

Parameters:
ctxHdl - context handle
tag - tag name
 o setIgnoreCase
 PROCEDURE setIgnoreCase(ctxHdl IN ctxType, flag IN NUMBER)
The XSU does mapping of XML elements to db. columns/attrs. based on the element names (xml tags). This function tells the XSU to do this match case insensitive.

Parameters:
ctxHdl - context handle
flag - ignore tag case in the XML doc? 0-false 1-true
 o setDateFormat
 PROCEDURE setDateFormat(ctxHdl IN ctxType, mask IN VARCHAR2)
Describes to the XSU the format of the dates in the XML document. The syntax of the date format patern (i.e. the date mask), should conform to the requirements of the java.text.SimpleDateFormat class. Setting the mask to null or an empty string, results the use of the default mask -- OracleXMLCore.DATE_FORMAT.

Parameters:
ctxHdl - context handle
mask - the date mask
 o setBatchSize
 PROCEDURE setBatchSize(ctxHdl IN ctxType, batchSize IN NUMBER);
Changes the batch size used during DML operations. When performing inserts, updates or deletes, it is better to batch the operations so that they get executed in one shot rather than as separate statements. The flip side is that more memory is needed to buffer all the bind values. Note that when batching is used, a commit occurs only after a batch is executed. So if one of the statement inside a batch fails, the whole batch is rolled back. This is a small price to pay considering the performance gain; nevertheless, if this behaviour is unaccepatable, then set the batch size to 1.

Parameters:
ctxHdl - context handle
batchSize - batch size
See Also:
DEFAULT_BATCH_SIZE
 o setCommitBatch
 PROCEDURE setCommitBatch(ctxHdl IN ctxType, batchSize IN NUMBER);
Sets the commit batch size. The commit batch size refers to the number or records inserted after which a commit should follow. Note that if commitBatch is < 1 or the session is in "auto-commit" mode then the XSU does not make any explicit commit's. By default the commit-batch size is 0.

Parameters:
ctxHdl - context handle
batchSize - commit batch size
 o setUpdateColumn
 PROCEDURE setUpdateColumn(ctxHdl IN ctxType, colName IN VARCHAR2);
Adds a column to the "update column list". In case of insert, the default is to insert values to all the columns in the table; on the other hand, in case of updates, the default is to only update the columns corresponding to the tags present in the ROW element of the XML document. When the update column list is specified, the columns making up this list alone will get updated or inserted into.

Parameters:
ctxHdl - context handle
colName - column to be added to the update column list
 o clearUpdateColumnList
 PROCEDURE clearUpdateColumnList(ctxHdl IN ctxType)
Clears the update column list.

Parameters:
ctxHdl - context handle
See Also:
setUpdateColumn
 o setKeyColumn
 PROCEDURE setKeyColumn(ctxHdl IN ctxType, colName IN VARCHAR2)
This methods adds a column to the "key column list". In case of update or delete, it is the columns in the key column list that make up the where clause of the update/delete statement. The key columns list must be specified before updates can be done; yet, it is only optional for delete operations.

Parameters:
ctxHdl - context handle
colName - column to be added to the key column list
 o clearKeyColumnList
 PROCEDURE clearKeyColumnList(ctxHdl IN ctxType)
Clears the key column list.

Parameters:
ctxHdl - context handle
See Also:
setKeyColumn
 o insertXML
 FUNCTION  insertXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
Inserts the XML document into the table specified at the context creation time.

Parameters:
ctxHdl - context handle
xDoc - string containing the XML document
Returns:
The number of rows inserted.
 o insertXML
 FUNCTION  insertXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
Inserts the XML document into the table specified at the context creation time.

Parameters:
ctxHdl - context handle
xDocl - string containing the XML document
Returns:
The number of rows inserted.
 o updateXML
 FUNCTION  updateXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
Updates the table specified at the context creation time with data from the XML document.

Parameters:
ctxHdl - context handle
xDoc - string containing the XML document
Returns:
The number of rows updated.
 o updateXML
 FUNCTION  updateXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
Updates the table specified at the context creation time with data from the XML document.

Parameters:
ctxHdl - context handle
xDocl - string containing the XML document
Returns:
The number of rows updated.
 o deleteXML
 FUNCTION  deleteXML(ctxHdl IN ctxType, xDoc IN VARCHAR2) RETURN NUMBER
Deletes records specified by data from the XML document, from the table specified at the context creation time.

Parameters:
ctxHdl - context handle
xDoc - string containing the XML document
Returns:
The number of rows deleted.
 o deleteXML
 FUNCTION  deleteXML(ctxHdl IN ctxType, xDoc IN CLOB) RETURN NUMBER
Deletes records specified by data from the XML document, from the table specified at the context creation time.

Parameters:
ctxHdl - context handle
xDocl - string containing the XML document
Returns:
The number of rows deleted.
 o propagateOriginalException
 PROCEDURE propagateOriginalException(ctxHdl IN ctxType, flag IN BOOLEAN)
Tells the XSU that if an exception is raised, and is being thrown, the XSU should throw the very exception raised; rather then, wrapping it with an OracleXMLSQLException.

Parameters:
ctxHdl - context handle
flag - propagate original exception? 0-false 1-true
 o getExceptionContent
 PROCEDURE getExceptionContent(ctxHdl IN ctxType, errNo OUT NUMBER, errMsg OUT VARCHAR2)
Via its arguments, this method returns the thrown exception's error code and error message (i.e. sql error code) This is to get around the fact that the jvm throws an exception on top of whatever exception was raised; thus, rendering pl/sql unable to access the original exception.

Parameters:
ctxHdl - context handle
errNo - error number
errMsg - error message