Sneha Sharma@CONTEXT
06/20/2000 10:09 AM
Hey!
Thanks a lot .Thats exactly what I was looking for,..
Regards
Sneha
"Matthews,Paul" <[EMAIL PROTECTED]> on 06/20/2000 11:58:01 AM
Please respond to A mailing list about Java Server Pages specification and
reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Sneha Sharma/Context)
Subject: Re: Stored Procedure
> This output parameter returns for eg. data in 2 cols.(as in a cursor)
Gah. Missed that bit. This'll do the trick for Oracle... needs tidying
callableStatement.registerOutParameter(x, OracleTypes.CURSOR);
.
.
.
results = (ResultSet) callableStatement.getObject(x);
while (results.next) {
something = results.getLong(1);
}
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
===========================================================================
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
