Various Techniques for calling stored procedures using java

[j.gohel]

Hello ,

Please help me understand the below technique of calling the Stored Procedure written in Oracle using java.In our application it is working fine but while surfing i found out that some people got exceptions using this technique and some of the experts recommended using the technique of
{call ... }

connection.prepareCall("begin XYZProc(?,?,?,?); end;");

Thanks in advance.

[Belisarius]

Honestly, I've only used prepared statements - I haven't used stored procedures before.

[technobard]

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.