Set your $dbh->{RowCacheSize} to 200, and use $sth->fetch in a loop
200 times. If you crank up your tracelevel to 3 or 4, you'll see that
OCI only hits the database once.
Look back in the archives about 1 month or so - I had a discussion of this
very issue with Tim Bunce.
--
j.
James FitzGibbon voice/fax 612-761-6121/4277
Consultant, TTS-3D@TPN4H [EMAIL PROTECTED]
> -----Original Message-----
> I'm using the current versions of DBI and DBD::Oracle. Is it
> possible
> to limit the number of rows returned by fetchall_xxx ? Basically, I
> want to retrieve up to (say) 200 rows, but utilise an array fetch, so
> only making round trip to the database. I know OCI supports
> this, but
> can't see anywhere in the DBI or DBD::Oracle doco that says how to.
