Re: bulk collect into ... limit N
From: Tony Adolph <tony.adolph.dba_at_gmail.com>
Date: Wed, 1 Jul 2009 17:22:08 +1200
Message-ID: <4a38d9060906302222r5e930ea9w73efe27540784235_at_mail.gmail.com>
The article by Steven Feuerstein (thanks Denis and Herald) says don't rely on %NOTFOUND when using bulk collect :
Date: Wed, 1 Jul 2009 17:22:08 +1200
Message-ID: <4a38d9060906302222r5e930ea9w73efe27540784235_at_mail.gmail.com>
The article by Steven Feuerstein (thanks Denis and Herald) says don't rely on %NOTFOUND when using bulk collect :
When you are using BULK COLLECT and collections to fetch data from your
> cursor, you should never rely on the cursor attributes to decide whether
> to terminate your loop and data processing.
It doesn't say why it works at the end of the loop though, but I'll leave it there. Just use %count on the collection instead. It reads better any way I reckon.
Thanks for all the feedback,
Cheers
Tony
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 01 2009 - 00:22:08 CDT