Array Fetching

[edwards_zhg]

Administrator:
Could you give me a simple example about
Array fetching?
and I have a Stored_procedure with an out parameter of cursor variable.but how can I
make use of the returned cursor variable and
get the record by using this cursor variable?
And what is oci and what is the difference
between oci7 and oci8?(Toraclesession.preference...)

 

[Marco Kalter]

There are 2 ways to retrieve records from a cursor variable. One way is to us 2 TOracleQuery instances (1 with the procedure call and 1 to represent the cursor). The other way is to use a TOracleDataSet that calls the stored procedure. The result set will be obtained from the cursor. Both methods are explained in detail in the Help File and User's Guide. Just search for "Cursor Variables".

OCI = Oracle Call Interface, which is the lowest level of communication with an Oracle Server. OCI7 is the version that is implemented by SQL*Net 2. OCI8 is the version that comes with Net8, and supports Net8 specific features such as the TLOBLocator, TOracleObject, Password Expiration, TOracleDirectPathLoader, MTS pooled sessions, and external procedure calls. The UseOCI7 preference can be used to circumvent possible OCI8 bugs that you may encounter in Net8.

------------------
Marco Kalter
Allround Automations