Re: OCI prefetching REF CURSORS

On May 22, 2:41 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> On Tue, 22 May 2007 05:01:50 -0700, remius wrote:
> > Hi All,
>
> > My application connects to an Oracle Server 9i via OCI. I have all my
> > select statements on stored procedures, for this I use REF CURSOR to
> > return the result sets. It is working correct but in some cases, because
> > one trip to the server is needed for each row returned by the stored
> > procedure, is very slow.
>
> > Is there any way to enable prefetching of rows when using stored
> > procedures and REF CURSORs ?
> > If not, is there any other possiblity to improve perfomance when using
> > ref cursor ?
>
> > Thanks in advance...
>
> Sounds like the array interface. You should bind (define?) the parameters
> to the array variables and fetch into the arrays. I remember somebody
> nagging and requesting the very same thing for Perl DBI.
>
> --http://www.mladen-gogala.com

Hi, thanks for your answer...

do you know where I can find any example about array binding ?

Thanks. Received on Tue May 22 2007 - 11:07:01 CDT