Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI Array Fetch Sample Code.
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<b0vhhus6kn7siroiht0ue93u12rjetiue7_at_4ax.com>...
> On 25 Jun 2002 12:47:22 -0700, xu98248_at_hotmail.com (Lijia Xu) wrote:
>
> >Hi,
> >
> >I'm trying to select 100k records from Oracle 9i via OCI. I used
> >prefetch method, but it's way too slow. Can I use array fetch to
> >improve the performance? Does anyone know where I can find some sample
> >code?
> >
> >Thanks a lot,
> >
> >Lijia
>
> In the OCI documentation?
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
In the documentation, it does not give any sample for array fetch, I'm not sure how to establish array fetching of a table with 8 fields, that's why I hope I can find some sample code as reference.
Thanks,
Lijia Received on Wed Jun 26 2002 - 08:45:27 CDT