PL/SQL - returning N records after a specific record

[cybertag]

Hi,

With PL/SQL I would like to:

1. retrieve a subset of rows ( ... sum(xxx) ... group by )
2. look up for one specific record in this subset
3. read N records after the retrieved record
4. return the result so I can read the records using
a Java 'CallableStatement'

I know how to get the data in Java but I don't
know how to generate the data in the stored procedure.

Any help would be appreciated.

Thank you very much

Didier