stored proc question

What is the best way to return the result of a select statement in a stored proceudre ?

For example :
I have a stored procedure called GetUsers (Group_name)

This pprocedure will get the users who belong to a given group.
Since I am using JDBC, I want to be able to access the result using java.sql.ResultSet
and traverse through it in my java program.

Thanks for your help in advance

Please don't post the same question to multiple forums. I already hit this question in the DBA forum.

Please close this one.

Thanks,

- Chris