Re: MAX Number of Records in Cursor ?

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 07 Jan 2003 06:33:47 -0800
Message-ID: <F001.005287A4.20030107063347@fatcity.com>

That I know of, there's no limit to the number of rows fetched by a cursor. I've certainly returned more rows than that.

Have you tried the sql statement in SQL*Plus? I know I advocate this a lot, but it does tell you if the problem is the sql itself. Are you SURE there are over 100K customers to get the mail? Do a select count(*) from the mail table. run a counter in your program every time you fetch from the cursor and another when you do an insert and display the counters at the end. Is there a exception that you aren't handling?

Standard debugging techniques.

• VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
  >
  > A Relationship manager needs to broadcast mail to all the Customers .
  > There are around 102,847 customer
  >
  > To achieve this functionality in our code we are opening a cursor,
  > fetching each
  > user id from a table and inserting into a mail table for each fetch.
  >
  > Mail is getting Generated for only 7130 Customers .
  > There are no oracle errors reported in the log files .
  >
  > Is there any size limitation in oracle while opening/fetching a
  > cursor as the No. of
  > records to be fetched are 102,847 ?
  >
  > Thanks
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: VIVEK_SHARMA
  > INET: VIVEK_SHARMA_at_infosys.com
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > 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).
  >
  

  ---

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Tue Jan 07 2003 - 08:33:47 CST