Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_XMLSAVE, 7 of 18
This procedure changes the batch size used during DML operations. When performing inserts, updates, or deletes, batching the operations so that they are not executed as separate statements will result in performance gains. However, more memory is needed to buffer all the bind values. When batching is used, a commit occurs only after a batch is executed. Therefore, if one of the statements inside a batch fails, the whole batch is rolled back. If this behavior is unacceptable, set the batch size to 1.
DBMS_XMLSAVE.setBatchSize (ctxHdl IN ctxType, batchSize IN NUMBER);
Table 73-7 shows the parameters of the setBatchSize
procedure.
Parameter | Description |
---|---|
|
The context handle. |
|
The batch size. |
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|