When calling a Stored Procedure with no arguments and no output is there any advantage to 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;";
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With