Results for ARRAY


1 to 20 of 1355 results. Prev  Next
Results per page:   20  | 40 | 60


Objects for OLE, 9i Release 2 (9.2.0.2)

Array Processing

Array ProcessingFeedback 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

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Working with Oracle Collections

ARRAY Descriptors and ARRAY Class FunctionalityThe 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The T ArraySelect 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The V ArraySelect 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The I ArraySelect 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The S ArrayN variable equal to the F variable. The S Array This array contains the addresses of data buffers

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The X ArrayYou 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The Y ArrayYou 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

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Host Arrays

Host Array Restrictionsarrays 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

LOB and FILE Operations

Array Interface For LOBsIt 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The Z Arrayindicator-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.

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The M ArrayYou 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.

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The L ArrayThis array contains the lengths of select-list or bind-variable values stored in the data buffers.

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Working with Oracle Collections

ARRAY Automatic IndexingIf 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Binding and Defining

OCI Array Interfaceuse 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

Pro*Fortran, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

The C ArrayYou 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Bulk Array Bindsarray-style syntax to get and set the values of elements. The subscripts of these elements need not be

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Working with Oracle Collections

ARRAY Performance Extension MethodsPrimitive Types ARRAY Automatic Element Buffering ARRAY Automatic Indexing

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Working with Oracle Collections

ARRAY Automatic Element BufferingThe 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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Tuning Networks

Using Array InterfacesReduce 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





Was this page helpful?

Integrated Cloud Applications & Platform Services