When should the two be used? I understand that callable statement is used for procedures but apart from that what are the advantages of callable statement over prepared statement.
Amit, The real question is what are the advantages of stored procedures vs prepared statements. The main one is that stored procedures are faster because run completely on the database while prepared statements are more portable.