I'm just getting into jsp pages and are having a bit of trouble calling an oracle-stored procedure. I've managed to do an insert by putting the sql in the page but I'd prefer to do it via a stored procedure. So can anyone help me?

I'm running tomcat 5.5.16 with oracle 9i hope this enough info for you

Thanks Jason

<%
Connection dbconn;
ResultSet rs;
PreparedStatement sql;
try
{
Class.forName("oracle.jdbc.OracleDriver");
try
{
boolean doneheading = false;
dbconn = DriverManager.getConnection("jdbc:oracle:thin:@tes tdtb:25005:testdtb","tuser","waikato");
sql = dbconn.prepareStatement("insert into tmp_a insert into tmp_a (field_1,field_2,field_3,field_4) values ('a','b','c','d') ");
rs = sql.executeQuery();
sql.close();
rs.close();
dbconn.close();
}
catch (SQLException s)
{
out.println(s.toString());
}
}
catch (ClassNotFoundException err)
{
out.println("Class loading error");
}
%>

from sqlplus I can
execute xtest_procedure ('a','b','c','d')
to do the same thing.
How do you execute the procedure from the jsp page?

procedure syntax
CREATE OR REPLACE PROCEDURE xtest_procedure
(
pfiled_1 IN tmp_a.filed_1%TYPE,
pfiled_2 IN tmp_a.filed_2%TYPE,
pfiled_3 IN tmp_a.filed_3%TYPE,
pfiled_4 IN tmp_a.filed_4%TYPE
) IS
BEGIN
insert into tmp_a
(field_1,field_2,field_3,field_4)
values
(pfield_1,pfield_2,pfield_3,pfield_4);
END xtest_procedure;
/