Re: Cursor For Loops

From: ALEX J JENTILUCCI <ALEXJENT_at_prodigy.net>
Date: Fri, 24 Apr 1998 17:46:59 -0500
Message-ID: <6hr599$754k$1@newssvr04-int.news.prodigy.com>

I'm not sure what Steve had in mind but it most likely is simply poor programming practice. In general, one way in and one way out of a block of code makes it real easy to maintain/understand.

Alex

David Temple wrote in message <353EC784.F3BB304E_at_deakin.edu.au>...
>Reading Oracle PL/SQL by Steven Feuerstein I find that it is a mortal
>sin to RETURN in the middle of a cursor for loop, although the author
>does not give a solid explanation of why, except to say that this is bad
>programming practice. Does anyone have a more thorough explanation?
>
>Thanks
>
>P.S I initially thought that the cursor would not get closed but on
>testing I find that it does get closed
Received on Fri Apr 24 1998 - 17:46:59 CDT