Re: fetch in array from ProC

I ran into this problem too. The way I got around it was to use an arraysize of 1 for the remaining records. You have to set up an extra set of variables, fetches, and loops, but it works. I'd be interested to hear if you find another way to do it.

"Sackwitz, Antje" wrote:

> Hi,
> I want to do the fetch of data against the Oracle 8.0.5 database by ProC
> using arrays.
> Til now I was not able to give the size of the array dynamically and if
> I say arraysize is 10, and I retrieve 28 records,
> the last 8 records will not be fetched as Oracle cannot fill up the
> entire array.
> any help is greatly appreciated.
>
> Regards,
> Antje
>
> -----------------------------------------------------------------
> Antje Sackwitz Phone: +49-431-7109-514
> Vossloh System-Technik GmbH Fax: +49-431-7109-675
> Edisonstr. 3 E-Mail: sackwitz_at_vst.vossloh.de
> 24145 Kiel
> -----------------------------------------------------------------
>
> --
> Author: Sackwitz, Antje
> INET: Sackwitz_at_vst.vossloh.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 22 2000 - 12:20:57 CDT