Yes with the newest driver you can cast a IN/OUT- or OUT-parameter from the
type oracle.refcursor into a ResultSet.
----- Original Message -----
From: Matthew Lehrian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 15, 1999 9:33 PM
Subject: Stored procedure JDBC question
> Hello group,
>
> I just started a project with JSP, JavaBeans, JDBC and Oracle. I can
query
> the database just fine from my bean. I would like to know if it's
possible
> to return a JDBC ResultSet from an Oracle stored procedure. If anybody
out
> there has done this, are there any pitfalls I should worry about? Does it
> work well? Is there some other way I should think about doing this?
>
> Thanks for your help!
>
> Matthew Lehrian - [EMAIL PROTECTED]
> Cross Current Senior Software Engineer
> (609) 397-3980
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
