> -----Mensaje original-----
> De: charu gupta [SMTP:[EMAIL PROTECTED]]
> Enviado el: martes 30 de octubre de 2001 0:42
> Para: [EMAIL PROTECTED]
> Asunto: exceuting oracle stored procedure in jsp
>
> Hi ,
>
> I have a oracle stored procedure which I call from my
> jsp.It is working fine.
> How can I check if the stored procedure was executed
> succesfully? Is there any value returned by the stored
> procedure which I can check in my jsp?
>
> Thanks,
> Charu
>
>
>
You may add a returning value to your stored procedure (it will
become a stored function ;)) and inside the code of the java stored, catch
any exception may occur and return a code or a message that you desire to
your JSP file.
Hope this helps
Fran
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
