Re: arraysize

A copy of this was sent to mguillem_at_my-dejanews.com (if that email address didn't require changing) On Mon, 29 Mar 1999 12:31:31 GMT, you wrote:

>Is there any mean to set the number of rows that a program using OCI will
>fetch from the database at one time, like the ARRAYSIZE with SQL*Plus?
>

Unless the program itself is 'array' capable -- no.

SQLPlus is written in OCI. The programmers of sqlplus support array fetching and allow you to 'tune' it by telling them how many rows to fetch at a time. It is only because they make the appropriate API calls with the correct inputs that they array fetch.

Array fetching is something you can do with OCI but you have to have done it.

>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation