Hi

say at the sqlplus prompt

var c refcursor

exec PackageName.ProcedureName('Name_to_be_searched', :c);

print c - this will output ur cursor values


HTH

SS