Try
CallableStatement cs = con.prepareCall("{call InsereItemAparencia( ? )}");
cs.setString(1, descricao2);
cs.execute() or cs.executeQuery(); depending on the result you want.
/Marcus
-----Original Message-----
From: Guilherme - PerConsult [mailto:[EMAIL PROTECTED]]
Sent: den 9 december 1999 17:18
To: [EMAIL PROTECTED]
Subject: stored procedure
Hi!!!
I`m trying to call a stored procedure using JSP... well, I have in my
form a text box called "descricao", and my sp will insert the value
written in my text box into the database.
--------
// "descricao" is the name of the text box
String descricao2 = request.getParameter("descricao");
// "InsereItem" is my stored procedure. I want to
// insert the value that are in the text box called
// "descricao" ... I think that here is my mistake..
CallableStatement cs = con.prepareCall("{call InsereItemAparencia
"descricao2"}");
---------
Any advice are welcome!!!!!!!!!!
xau,
guilherme
Guilherme dos Santos Tsubota
_________________________________
Perrotti Informatica - PerConsult
Sao Paulo - SP - Brazil
===========================================================================
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
