Re: fetch in array from ProC

From: Rajagopal Venkataramany <rajagopalvr_at_hotmail.com>
Date: Mon, 22 May 2000 16:34:19 GMT
Message-Id: <10505.106248@fatcity.com>

Hi,

I would suggest that you look at your code for the condition on when your quit the loop.

Assuming that you have declared a array size of 10,

  in the first attempt --> 10 rows will be fetched, no EOF signalled
  in the second attempt --> 10 rows will be fetched, no EOF signalled
  in the third attempt --> 8 rows will be fetched, EOF is signalled

Is it possible to send the code because it looks like a programming error to me...

Regards
Rajagopal Venkataramany

----Original Message Follows----

From: "Sackwitz, Antje" <Sackwitz_at_vst.vossloh.de> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: fetch in array from ProC
Date: Mon, 22 May 2000 07:25:36 -0800

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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Received on Mon May 22 2000 - 11:34:19 CDT