December 2002
Intermediate to advanced
928 pages
85h 29m
English
FUNCTION DBMS_XMLSAVE.newContext
(targetTable IN VARCHAR2)
RETURN ctxType;
Returns the context handle for targetTable.
PROCEDURE DBMS_XMLSAVE.closeContext
(ctxHandle IN ctxType);
Closes and deallocates ctxHandle.
PROCEDURE DBMS_XMLSAVE.setRowTag
(ctxHandle IN ctxType,
tag IN VARCHAR2);
Gives row tag for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setIgnoreCase
(ctxHandle IN ctxType,
flag IN NUMBER);
Specifies whether to ignore case on mapping of XML elements to database columns and attributes for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setDateFormat
(ctxHandle IN ctxType,
mask IN VARCHAR2);
Sets the date format to mask for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setBatchSize
(ctxHandle IN ctxType,
batchsize IN NUMBER);
Sets the batch size to batchsize for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setCommitBatch
(ctxHandle IN ctxType,
batchsize IN NUMBER);
Sets the commit batch size to batchsize for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setSQLToXMLNameEscaping
(ctxHandle IN ctxType,
flag IN BOOLEAN := TRUE);
Turns on and off escaping XML tags in case the SQL object name is not a valid XML identifier for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setUpdateColumn
(ctxHandle IN ctxType,
colname IN VARCHAR2);
Adds colname to update column list for ctxHandle.
PROCEDURE DBMS_XMLSAVE.clearUpdateColumnList
(ctxHandle IN ctxType);
Clears update column list for ctxHandle.
PROCEDURE DBMS_XMLSAVE.setPreserveWhitespace
(ctxHandle IN ctxType,
flag IN BOOLEAN := TRUE);
Turns on and off whitespace preservation for ctxHandle.
PROCEDURE ...