"asundaram" <member22031_at_dbforums.com> wrote in message
news:2363686.1042059643_at_dbforums.com...
>
> 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.
In principle I don't see why you can't return a result set object from a JSP
(see http://www.enterprisedt.com/publications/oracle/result_set.html) for
the generic case but I would suspect that PL?SQL might be a better choice
for you if you are doing DML in the stored proc.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jan 09 2003 - 10:12:27 CST
