PL/SQL Packages DBMS_XMLSAVE

XML to database-type functionality.

Subprocedures:

newContext Function
              Create a save context and return the context handle. 

closeContext  Close or de-allocate a particular save context. 

setRowTag     Name the tag used in the XML document to enclose the XML elements
              corresponding to database records 

setIgnoreCase 

setDateFormat Describes to the XSU the format of the dates in the XML document. 

setBatchSize  Change the batch size used during DML operations. 

setCommitBatch 
              Set the commit batch size. 

setUpdateColumn 
              Add a column to the update column list. 

clearUpdateColumnList 
             Clears the update column list. 

setKeyColumn 
             Add a column to the key column list. 

clearKeyColumnList 
             Clear the key column list. 

insertXML Function
             Insert the XML document into the table specified at the
             context creation time.   

updateXML Function
             Update the table specified at the context creation time
             with data from the XML document.  

deleteXML Function
             Delete records specified by data from the XML document,
             from the table specified at the context creation time. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

"Until a business returns a profit that is greater than its cost of capital, it operates at a loss.
Never mind that it pays taxes as if it had a genuine profit.
The enterprise still returns less to the economy than it devours in resources...
Until then it does not create wealth; it destroys it." - Peter Drucker, Harvard Business Review



 
Copyright © 1999-2024 SS64.com
Some rights reserved