Re: PL/SQL Questions

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: Fri, 06 Nov 1998 14:32:45 GMT
Message-ID: <364305b2.270456085@news.brookes.ac.uk>

On Tue, 03 Nov 1998 03:44:30 +0000, Patrick Lanphier <planphier_at_psu.edu> wrote:

>Ed Wallace wrote:

>>
>> Two questions - 1st - knowing that I'm not supposed to use an exit to
>> terminate a cursor FOR loop, what is the best way to get a single 'row' of
>> data? Is a cursor even the best way? One example of where I am doing this
>> is I am selecting and ordering data. I am fetching into a list of
>> variables the first ordered occurrence of this data. These variables are
>> then written to an output file. Then I exit my cursor. Any better way to
>> do this?

I give up, and finally bite.
Why shouldn't we exit to terminate a FOR loop? Is this the 'only one exit point' idea, or is there something else going on.

The manuals (hah hah!) don't mention this, I think.

--
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389 Received on Fri Nov 06 1998 - 08:32:45 CST