When calling a Stored Procedure with no arguments and no output is there any advantage t开发者_Go百科o using a CallableStatement over a regular Statement or PreparedStatement?
CallableStatement
allows you to use a generic JDBC syntax for calling procedures rather than a Database specific one.
Sadly, we didn't do that for Oracle in one of the projects I've worked on, so all our procedure calls look something like this:
String query = "begin package.sp_Procedure(?, ?); end;";
精彩评论