returning ResultSet from Java Stored Procedure

How can I go about returning a result set from a Java Stored Procedure loaded into Oracle? I want to call the procedure from a Java application. So far I've been able to return strings and integers. But how would i return an entire result set? how would the publishing of the Stored Proc. look? Is this even possible? Are Oracle Cursors required to do this?
Thanks.

--
Posted via http://dbforums.com