What is better approach for executing the stored procedure if we use either Prepared Statement or Callable statement ?
Is there any performance difference ???
Thanks in advance Deepika
Joined: Oct 13, 2001
Hi Use a PreparedStatement when you execute the same statement more than once. Use CallableStatement to execute stored procedures. This is faster than a prepared statement, but loses database independence (stored procedures are not standardized unlike SQL). I think this explanation might helpful. Regards, Sarada Prapoorna.V
"Prapoorna" Your name does not comply with the JavaRanch naming standard described at http://www.javaranch.com/name.jsp I also notice that you have changed your name from a valid name to this invalid name. Please change it back, since your account will be locked otherwise. Dave