When calculating a bind array size for a control file that has multiple INTO
TABLE
clauses, calculate as if the INTO
TABLE
clauses were not present. Imagine all of the fields listed in the control file as one, long data structure—that is, the format of a single row in the bind array.
If the same field in the data record is mentioned in multiple INTO
TABLE
clauses, then additional space in the bind array is required each time it is mentioned. It is especially important to minimize the buffer allocations for such fields.