Re: DBMS_SQL.CURSOR: How to check if Last Row has been reached ?

For 'normal' cursors I use

exit when cursor_name%not_found;

Maybe that will work for this cursor???

"Filiz Duman" <filiz.duman_at_bt.com> wrote in message news:amv21a$229$1_at_pheidippides.axion.bt.co.uk...
> I have following Cursor:
>
> l_cursor := DBMS_SQL.OPEN_CURSOR;
> DBMS_SQL.PARSE(l_cursor, l_sqlStatement, DBMS_SQL.native);
> l_retVal := DBMS_SQL.EXECUTE(l_cursor);
>
> loop
> l_retVal := DBMS_SQL.FETCH_ROWS(l_cursor);
>
> /* do different things */
>
> end loop
>
> Within the loop how can I check:
>
> if (last row)
> then....
>
> Many thanks in advance.
>
>
>
>
Received on Thu Sep 26 2002 - 11:09:15 CDT