Take a look at the CallableStatement class
callableStatement.registerOutParameter(15, Types.NUMERIC);
callableStatement.execute();
int errorCode = callableStatement.getInt(15);
Regards, Paul
> -----Original Message-----
> From: Sneha Sharma [mailto:[EMAIL PROTECTED]]
> Sent: 20 June 2000 16:34
> To: [EMAIL PROTECTED]
> Subject: Stored Procedure
>
>
> Sneha Sharma@CONTEXT
> 06/20/2000 08:33 AM
>
> Its an urgent requirement.
> I have to make a call to a stored proc and I want that one of the
> parameters should be mapped to an output parameter from the
> stored proc.
> This output parameter returns for eg. data in 2 cols.(as in a cursor)
> Please send a code snippet.
> Thanks,
> Sneha
>
> ==============================================================
> =============
> To unsubscribe: mailto [EMAIL PROTECTED] with body:
> "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
