Re: :Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc?

On Fri, Jan 19, 2007 at 05:24:53PM -0700, Joel Noble wrote:
> Thanks -- will give that a try.
> 
> Can I assume this means you believe that DBD::Oracle/DBI should 
> indeed be pre-caching rows in the reading from the cursor that was 
> received from the procedure?  That is, it is reasonable to think that 
> it should be doing pre-caching and that it's a bug (configuration 
> problem, etc.) that it's not working?  This is my assumption, but I'm 
> not sure -- perhaps I'm expecting something that doesn't really work that 
> way.

This topic has cropped up from time to time.  I believe the code does
the right thing and that the issue _may_ be related to specific Oracle
versions. But then again I don't recall anyone specifically saying it
worked for them. Check the archives for more detail.

Tim.

• DBD::Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc? by Joel Noble
• Re: DBD::Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc? by Joel Noble
• Re: DBD::Oracle: Row cache fetch ahead on cursor returned from PL/SQLstored proc? by Charles Jardine
• RE: :Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc? by Reidy, Ron
• RE: :Oracle: Row cache fetch ahead on cursor returned fromPL/SQL stored proc? by Joel Noble
• Re: :Oracle: Row cache fetch ahead on cursor returned from PL/SQL stored proc? by Tim Bunce