My Java Tips

Stored procedures contain set of SQL statements and are stored on the database server. Their query execution plan is already define, so they run faster and improve the performance. In this post, I will talk about how to call stored procedures.

---

An object of CallebleStatement (extends PrepareStatement) is used to execute store procedures. PrepareCall() method is use to create CallebleStatement’s object.

Java Code:

CallebleStatement cst;
Cst = conn.prepareCall(“{call

...

Tags: calleblestatement, preparestatement, stored procedure

Categories

JDBC