Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OCI Array Fetch Sample Code.

Re: OCI Array Fetch Sample Code.

From: Lijia Xu <xu98248_at_hotmail.com>
Date: 26 Jun 2002 06:45:27 -0700
Message-ID: <aa544eb1.0206260545.3794047d@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US