Re: returning ResultSet from Java Stored Procedure

On Wed, 08 Jan 2003 21:00:43 +0000, asundaram wrote:

>
> 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

I am hazy on this, but ResultSet objects are, I believe, not easyu to transfer, since they do not implement java.io.Serializable.

Cheers,

dmz17 Received on Wed Jan 08 2003 - 16:25:08 CST