| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MAX Number of Records in Cursor ?
Very good point, Jared.
We experienced similar fiasco when installing a vendor supplied appl called JourneyX (for tracking how and where we spend our time at work). After it was released for use, some set up in the Appl caused a flood of e-mails to all employees. Took almost a full day to 'clean' up the mess it caused.
-----Original Message-----
Sent: Tuesday, January 07, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L
Apart from the other replies, I would say that if you do get this to work properly, your mail admin is going to grab a big stick and come looking for you.
Sending out 100K individual emails at one time is not usually a good idea. Ask me how I know. ;)
I'm not an email expert by any means, but I do know not to do this.
Generate your email and use some external program that will mail it more efficiently. UTL_SMTP does not appear to the best method for mailing large amounts of email at one whack.
Maybe someone on the list knows how oracle does it in their email product.
Jared
"VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com>
Sent by: root_at_fatcity.com
01/07/2003 05:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: MAX Number of Records in Cursor ?
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: Jared.Still_at_radisys.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: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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 Wed Jan 08 2003 - 07:50:11 CST
 |
 |