RE: fetch in array from ProC

Hi Antje,

The records will be fetched, however they dont fill the entire array. In this case, Oracle will return no data found (1403) and fill the array with the records found. In sqlca.sqlerrd[2] you can see the cumulative count of records found.

HTH Carlos

> ----------
> De: Sackwitz, Antje[SMTP:Sackwitz_at_vst.vossloh.de]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Lunes 22 de Mayo de 2000 12:25
> Para: Multiple recipients of list ORACLE-L
> Asunto: fetch in array from ProC
>
> 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 - 10:18:14 CDT