Quote:
Originally Posted by j.gohel
some of the experts recommended using the technique of
{call ... }
|
Hmmmm... I've used {call....} before. I didn't know the other existed until now, but it makes sense. prepareCall is intended to be used if you want to call the same stored procedure multiple times with different parameters. The question marks (?) are placeholders, the same as when you use a prepareStatement. "Call" is intended for a single execution. There is nothing to stop you from using "Call" multiple times. The advantage of "prepare" anything is that bind variables are used. This eliminates the need to parse the statement at the database level every time you execute it. This is important for scalability for applications supporting a lot of users.