Please HELP! (packaging of data from Oracle)

I am having a discussion with my DBA about the packaging of data being retrieved by Oracle. She says that she has been told that with a Windows/VB client, there is NO middleware which will can receive the data in entire recordsets (naturally within the limit of cache sizes).  

While looking through the Objects For OLE docs, I discovered a "FetchLimit".
In the description of the "FetchLimit", the docs indicate that it is used
to set the number of elements in the array (what array they are talking about, I'm not sure) into which the data is retrieved. It also says that
changing the value (doesn't say changing it to anything specific) will cause ALL data to IMMEDIATELY be written to cache.

My DBA says that this merely means that the "FetchLimit" is setting the number of rows that are written to the cache on the server, but the rows are STILL sent one-by-one to the client.

1. Does "number of elements in the array" translate to number of rows?
2. Does this "cache" refer to a cache on the server or on the client?
3. Do we have any control at ALL of how the data is sent? (The server is an HP-9000, protocol is IPX/SPX)

Any help on this issue would certainly be appreciated. Please reply by e-mail
Thanx!!!

Jack Schwartz
Sr. Programmer/Analyst
thecat_at_nwlink.com Received on Mon Jun 10 1996 - 00:00:00 CEST