Calling Oracle PL/SQL stored procedure from JSP

[slimbim]

Can anyone help me or guide me to a website/page where I can find this information?

For example, I have Oracle PL/SQL stored procedures that take parameters and inserts these parameter values to a table. How do I call and pass in values to the stored procedure from JSP???

Thank you!

 

[kamper]

AHH! People have to stop talking about databases and jsp :| It's databases and java (or jdbc to be more correct). The fact that you're doing it from a jsp is bad but irrelevant... </rant> Sorry

Now, here's what you want: http://java.sun.com/j2se/1.5.0/docs/api...x.html?java/sql/CallableStatement.html

I assume that it'll work for oracle because it's supposed to but I have had problems with postgres and CallableStatement so I fell back on the PreparedStatement and normal syntax as you'd find it in plain sql. Maybe that's not necessary for you but there might be multiple ways to do it.