Hi List

I am opening a REF CURSOR as follows:
OPEN mycursor FOR
SELECT blah , blah
WHERE blah=bhah;

How to get the rowcount. SQL%ROWCOUNT ,
mycursor%ROWCOUNT donot give errors but return null.
I donot want to open a loop, fall into the loop and
keep counting.

Any ideas?

TIA

===============
Not So Lazy DBA
===============


=====
LayZee DBA

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page