Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Catalogue of SQL and PL/SQL bad practices: Call for participation
Gojko Adzic wrote:
> HI Daniel,
>
> thanks. Could you be a bit more specific about the cursor loop?
Cursor loops have been obsolete in Oracle since the release of 9i. Any procedural processing should be based on bulk collecting into arrays using BULK COLLECT and then put back onto disk using FORALL.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Dec 20 2007 - 15:05:57 CST
![]() |
![]() |