Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??

Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??

From: Haggai <haggai_shachar_at_hotmail.com>
Date: Tue, 15 Jun 1999 09:10:34 +0300
Message-ID: <7k4ujo$4qv$1@news.netvision.net.il>


I prefer using:

cursor_name.open
cursor_name.fetch (a);
while cursor_name%found and cursor_name%rownum < 10 loop

    .
    .
    .

    cursor_name.fetch (a);
end loop;

cursor_name.close;

I'm not sure about the syntax, but the main idea is to transform your FOR loop to WHILE loop. (which you can control the exit condition)

        Haggai.
        haggai_shachar_at_hotmail.com


Andy Hardy wrote in message ...
>Hello,
>
>I used a cursor FOR LOOP to work my way through some ordered data. I now
>want to limit the number of rows considered using something like ROWNUM.
>However, as ROWNUM is considered before ORDER I cannot simply add it to
>the query.
>
>I *could* create a FOR LOOP with an EXIT clause based on the %ROWCOUNT,
>but wonder if this is the *correct* way to do this or would it upset the
>Oracle cursor management?
>
>Any thoughts?
>
>E.G
>
>CURSOR my_csr
>IS
>SELECT a, b, C
> FROM my_table
> ORDER BY d
>;
>
>FOR v_data IN my_cursor LOOP
> EXIT WHEN my_cursor%ROWCOUNT > 5;
> -- do the real work
> --
>END LOOP;
>
>--
>Andy Hardy. PGP key available on request
>===============================================================
Received on Tue Jun 15 1999 - 01:10:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US