Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

72
DBMS_XMLQUERY

DBMS_XMLGEN is a built-in package in C. In general, use DBMS_XMLGEN instead of DBMS_XMLQUERY wherever possible. DBMS_XMLQUERY provides database-to-XMLType functionality.

See Also:

Oracle9i XML Reference for more information 

This chapter discusses the following topics:

Summary of DBMS_XMLQUERY Subprograms

Table 72-1 DBMS_XMLQUERY Subprograms  
Subprogram  Description 

"newContext Function" 

Creates a query context and returns the context handle. 

"newContext Function" 

Creates a query context and returns the context handle. 

"closeContext Procedure" 

Closes or de-allocates a particular query context. 

"setRowsetTag Procedure" 

Sets the tag to be used to enclose the XML dataset. 

"setRowTag Procedure" 

Sets the tag to be used to enclose the XML element corresponding to a database record. 

"setErrorTag Procedure" 

Sets the tag to be used to enclose the XML error docs. 

"setRowIdAttrName Procedure" 

Sets the name of the id attribute of the row enclosing the tag. 

"setRowIdAttrValue Procedure" 

Specifies the scalar column whose value is to be assigned to the id attribute of the row enclosing the tag. 

"setCollIdAttrName Procedure" 

Sets the name of the id attribute of the separator tag of the collection element. 

"useNullAttributeIndicator Procedure" 

Specifies whether to use an XML attribute to indicate nullness, or to do it by omitting the particular entity in the XML document. 

"setTagCase Procedure"  

Specifies the case of the generated XML tags. 

"setDateFormat Procedure" 

Sets the format of the generated dates in the XML document. 

"setMaxRows Procedure"  

Sets the maximum number of rows to be converted to XML. By default, no maximum is set. 

"setSkipRows Procedure" 

Sets the number of rows to skip. By default, 0 rows are skipped. 

"setStylesheetHeader Procedure" 

Sets the stylesheet header (i.e. stylesheet processing instructions) in the generated XML document.  

"setXSLT Procedure" 

Registers a stylesheet to be applied to the generated XML. 

"setXSLT Procedure" 

Registers a stylesheet to be applied to the generated XML. 

"setBindValue Procedure" 

Sets a value for a particular bind name. 

"setMetaHeader Procedure" 

Sets the XML meta header. 

"setDataHeader Procedure" 

Sets the XML data header. 

"setRaiseException Procedure" 

Tells the XSU to throw the raised exceptions. 

"setRaiseNoRowsException Procedure" 

Tells the XSU whether or not to throw an OracleXMLNoRowsException when the XML document generated is empty. 

"propagateOriginalException Procedure" 

Tells the XSU that if an exception is raised, the XSU should throw that exception rather than wrapping it with an OracleXMLSQLException. 

"getExceptionContent Procedure" 

Returns the error code of the thrown exception and the error message (that is, the SQL error code). 

"getDTD Function" 

Generates the DTD based on the SQL query used to initialize the context. 

"getDTD Procedure" 

Generates the DTD based on the SQL query used to initialize the context. 

"getXML Function" 

Generates the XML document based on the SQL query used to initialize the context. 

"getXML Procedure" 

Generates the XML document based on the SQL query used to initialize the context. 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback