returning modified resultsets

How do I write a stored procedure that is returning only a subset of a resultset.

I know I have to make a package and declare the result type as ref cursor when I want to return a resultset.

But my problem is that I only want to return a subset of the resultset - where the condition for including (or excluding) is not possible to specify in the select statement.

I want to do something like

for
  select field_a,Field_b,Field_c from table   into a,b,c
do
  if somecondition then return (a,b,c) Received on Mon May 09 2005 - 07:36:09 CDT