('binary' encoding is not supported, stored as-is)
Besides, Vivek, have you ever heard about INSERT ... SELECT ? Why, I ask, do you want to loop ?
>----- Original Message -----
>From: tim_at_sagelogix.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Tue, 07 Jan 2003 05:54:17
>
>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: Stephane Faroul
INET: sfaroult_at_oriolecorp.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:38:51 CST
