Determining number of rows returned by a cursor

I am writing some procedure in pl/sql. Assuming I have a cursor such as:

cursor mycursor (mysearch in varchar2) is

   select name, id
   from employee
   where upper(name) like '%' || upper(mysearch) || '%'

is there any way to determine the number of rows returned by such a cursor so that I could do something like:

if mycursor%RECORDCOUNT then

• do something that involves the cursor else
• let the user know their search failed end if;

I know about %ROWCOUNT, but I would like to know before I actually execute the cursor whether or not it will return rows.

Thanks.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 26 1999 - 18:16:35 CDT