setCommitBatch Procedure

This procedure sets the commit batch size. The commit batch size refers to the number of records inserted after which a commit should follow. Note that if the commitBatch is less than 1 or the session is in autocommit mode, the XSU does not make any explicit commits. By default the commit-batch size is 0.

Syntax

DBMS_XMLSAVE.	setCommitBatch (

ctxHdl     IN ctxType, 
batchSize  IN NUMBER); 

Parameters

Table 73-8 shows the parameters of the setCommitBatch procedure.

Table 73-8 setCommitBatch Procedure Parameters

Parameter	Description
ctxHdl (IN)	The context handle.
batchSize (IN)	The commit batch size.