Re: cursors and sql%rowcount

Just read up on working with cursors.
Define an explicit cursor
Declare a variable as cursor%ROWTYPE;
Open cursor;
fetch cursor into <variable>;
close cursor;

That's all.
Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> wrote in message news:89ovce$qbo$1_at_nnrp1.deja.com...
> Hi,
>
> I have a cursor that can return one or several hundred rows at a time.
>
> The thing is, I only ever want just the first row. Right now I'm
> executing the cursor in a FOR LOOP. Then, IF SQL%ROWCOUNT = 1, I get the
> values for the first row returned then halt executing of the loop with a
> RETURN statement.
>
> It's just that this seems a clunky way to do this. Is there any other
> way to limit the result set?
>
> The sql statement does not lend itself to limiting output,
> unfortunately. And I cannot use ROWID for this purpose, as the data
> retrieved by the cursor is not necessarily sequential.
>
> thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 03 2000 - 00:00:00 CST