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 SS64.com 1999-2013
Some rights reserved