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
Related Commands:
Related Packages: