set bulk array size establishes the number of rows that will be buffered in local server memory before they are transferred with the bulk copy interface. The syntax for set bulk array size is:
set bulk array size number
The value of number indicates the number of rows to buffer. If the rows being transferred contain text, image, or Java Abstract Data Types (Java ADTs), the bulk copy interface ignores the current setting for array size and uses a value of 1. Also, the array size actually used never exceeds the value of @@bulkbatchsize. If @@bulkbatchsize is smaller than the array size, then the smaller value is used.
