Array Processing → Feedback Array Processing OO4O supports an array interface to an Oracle database through OraParamArray … object. The array interface enables the transfer of bulk of data in single network trip. This is … example, in order to insert 100 rows into remote database without array processing, ExecuteSQL
ARRAY Descriptors and ARRAY Class Functionality → The section introduces ARRAY descriptors and lists methods of the ARRAY class to provide an … overview of its functionality. ARRAY Descriptors Creating and using an ARRAY object requires the existence … the collection being materialized in the array. You need only one ArrayDescriptor object for any
The T Array → Select Descriptors DESCRIBE sets the array of lengths to the maximum expected for each select-list … the section \"Converting Data\". Bind Descriptors You must set the array of lengths before issuing … need. Each input or output buffer can have a different length. The T Array This array contains the
The V Array → Select Descriptors DESCRIBE sets the array of datatype codes to the internal datatype (for example … ). Bind Descriptors DESCRIBE sets the array of datatype codes to zeros. You must reset the datatype … character strings, so the datatype array elements are set to 1 (the VARCHAR2 datatype code). To change the … you want. The V
The I Array → Select Descriptors You must set this array before issuing the FETCH command. The following … SELV address elements of a data buffer array named SELVB, Oracle stores the Jth select-list value … in SELVB(J). Bind Descriptors You must set this array before issuing the OPEN command. The following … elements of BNDV address elements
The S Array → N variable equal to the F variable. The S Array This array contains the addresses of data buffers
The X Array → You must set the elements of the I array using SQLADR. Select Descriptors You must set this array … buffer array named SELIV, and the Jth returned select-list value is , SELIV(J) is set to -1. Bind … Descriptors You must initialize this array and set the associated indicator variables before issuing … the elements
The Y Array → You must set the elements of the X array using SQLADR before issuing the DESCRIBE command. DESCRIBE … BNDX(BNDN). If the elements of BNDX address elements of a data buffer array named BNDXB, Oracle stores … the Jth indicator-variable name in BNDXB(J). The Y Array This array contains the maximum lengths of … X
Host Array Restrictions → arrays in the INTO clause of a SELECT or FETCH statement. If any of the host variables is an array … : Table 8-1 Valid Host Arrays for SELECT INTO INTO Clause WHERE Clause Valid? array array no scalar scalar yes array scalar yes scalar array no
Array Interface For LOBs → It is possible to use the OCI's array interface with LOBs, just as with any other datatype. Note … , however, that you must do the following to allocate the descriptors: /* First create an array of
The Z Array → indicator-variable name buffer can have a different length. The Z Array This array contains the actual … lengths of indicator-variable names. Like the X and Y arrays, you can use the Z array only with bind descriptors.
The M Array → You must set the elements of the S array using SQLADR before issuing the DESCRIBE command. DESCRIBE … ). The M Array This array contains the lengths of the data buffers that store select-list or placeholder … names. The buffers are addressed by elements of the S array.
The L Array → This array contains the lengths of select-list or bind-variable values stored in the data buffers.
ARRAY Automatic Indexing → If an array is in auto-indexing mode, the array object maintains an index table to hasten array … element access. The oracle.sql.ARRAY class contains the following methods to support automatic array … the array object a hint: specify this parameter to help the JDBC driver determine the best indexing
OCI Array Interface → use the Oracle array interface and input many values with a single statement and a single call to … OCIStmtExecute(). In this case you bind an array to an input placeholder, and the entire array can be … passed at the same time, under the control of the iters parameter. The array interface significantly … possible
The C Array → You must set the elements of the M array before issuing the DESCRIBE command. Each select-list or … placeholder name buffer can have a different length. The C Array This array contains the actual … lengths of select-list or placeholder names. DESCRIBE sets the array of actual lengths to the number of characters in each
Bulk Array Binds → array-style syntax to get and set the values of elements. The subscripts of these elements need not be
ARRAY Performance Extension Methods → Primitive Types ARRAY Automatic Element Buffering ARRAY Automatic Indexing
ARRAY Automatic Element Buffering → The Oracle JDBC driver provides public methods to enable and disable buffering of ARRAY contents … -buffering is disabled. It is advisable to enable auto-buffering in a JDBC application when the ARRAY … the ARRAY data is able to fit into the JVM memory without overflow). Important: Buffering the
Using Array Interfaces → Reduce network calls by using array interfaces. Instead of fetching one row at a time, it is more … efficient to fetch 10 rows with a single network round trip. See Also: Oracle Call Interface Programmer's Guide for more information on array interfaces