Re: MAX Number of Records in Cursor ?

There are no limits on the number of rows which can be retrieved. Please check the query and the application code surrounding it more closely.

I'd suggest extracting the query into SQL*Plus and running it there. If the behavior is as expected, then the surrounding application code is at fault. Else, the query is faulty...

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: tim_at_sagelogix.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).