You sure can. We do it quite a bit, and it works just fine.
Here's a small code snippet from the JSP end with tons removed.:
OracleCallableStatement theStatement = null;
try
{
theStatement = (OracleCallableStatement) connection.prepareCall("{?=
call the_stored_procedure(?,?,?,?,?,?,?)}");
...
----- Original Message -----
From: Matthew Lehrian <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 15, 1999 1: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
