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