Re: No of rows fetched by PL/SQL cursor

From: <G.Plivna_at_itsystems.lv>
Date: Wed, 17 Jan 2001 13:30:43 +0200
Message-Id: <10744.126866@fatcity.com>

Hi!

This is "TOTAL NO OF ROWS FETCHED by a cursor" so far ;))))))

I think the only way to get to know the count of records is to loop through the cursor and
issue <cursor_name>%ROWCOUNT before closing the cursor.

Or to modify cursor so it is like SELECT count(*) instead of SELECT col1, col2 ...

Gints

Thankx for help
But I actually want TOTAL NO OF ROWS FETCHED by a cursor
In pro*c we have sqlca.sqlerrd[2] like this is there any utility in PL/SQL
Regards
Bipin
--- G.Plivna_at_itsystems.lv wrote: >
>
> <cursor_name>%ROWCOUNT
>
> Gints
>
> >Hi,
> >Can anyone tell me how to know no. of rows fetched
> >by PL/SQL cursor in anonymous PL/SQL block
> >Thankx in advance
> >Regards
> >Bipin
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
Received on Wed Jan 17 2001 - 05:30:43 CST