getting rowcount from weak refcursor

[mileni]

Hy,
i have a package with procedure like this
xxx(refcur out sys_refcursor, numrows out number)
begin
open refcur for
select * from table;
numrows := refcur%rowcount; -- this is ZERO!!!
end xxx;

i need to know if there is some solution to read hove many rows are there without looping thru rows or executing another equal select???
Thanks, Alen

 

[sem]

To count rows you may open another cursor for SELECT COUNT(*) FROM TABLE. But in any case you should FETCH some data to obtain result.

Regards, Dima

 

[mileni]

Thanks, man!
I'm trying to avoid writing another cursor and to fetch it, but it seems to me that it is not possible...

Thanks, anyway!!!
Alen