Hi,
In the stored procedure return a value (say a variable called status_v of
type varchar).
Now using the following code
exception
when others then
status_v:=sqlcode||' : '||sqlerrm;
in the procedure, u can make the value of status_v pass to the front end.
Thus u will get a error code as well as the error message from the Oracle
side.
with regards,
Badri
----- Original Message -----
From: "Francisco Manuel Mart�nez Su�rez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 30, 2001 5:50 PM
Subject: Re: exceuting oracle stored procedure in jsp
> > -----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
==========================================================================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
