|
Difference between Statement and Callable Stmt.
Hello everybody,
Please clear my following doubt :
I use java.sql.Statement object to call a stored procedure.
Eg :
ResultSet res = stmt.executeQuery(\"select now()\");
This returns me the current database time.
If this is the case, why should I go for a Callable Statement?
It is used exclusively used to call stored procedures. I f I can call the stored procedure through a Statement object, why should there be a Callable Statement?
|