i'm pretty sure that java stored procs cannot return refcursors. the
only alternative i can think of would be to use custom sql record
types (representing a row of the resultset you want) in the database,
and have the java stored procedure return a collection of them. your
client code would have to be aware of the sql type. i would consider
this a roundabout way of doing it -- are you absolutely sure you need
to use java stored procedures instead of pl/sql?
asundaram <member22031_at_dbforums.com> wrote in message news:<2366905.1042124218_at_dbforums.com>...
> In that case, do you know of an alternative I could use? I want my Java
> Stored Proc. to return multiple rows from a table. Do you know of an
> object I could return and what SQL type it maps to? (either in Oracle 8i
> or 9i). thanks,
> -Arun
Received on Thu Jan 09 2003 - 13:04:13 CST
