Prepared Statement Vs. Callable Statement
Amit M Singh
Greenhorn
Posts: 2
posted 13 years ago
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.
I understand that callable statement is used for procedures but apart from that what are the advantages of callable statement over prepared statement.
posted 13 years ago
CallableStatement
is the interface used to execute SQL stored procedures
[ March 23, 2004: Message edited by: Joe Ess ]
is the interface used to execute SQL stored procedures
[ March 23, 2004: Message edited by: Joe Ess ]
posted 13 years ago
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.
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.
[OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
| It is sorta covered in the JavaRanch Style Guide. |