1. Home >
  2. Apps >
  3. Groups >

how to call a three procedures in a single statement?

Question asked by kunaljd in #Coffee Room on Dec 27, 2010
kunaljd
kunaljd · Dec 27, 2010
Rank C3 - EXPERT
I am currently facing this problem. i have to write a single callable statement that will call three procedures and calling second procedure from first procedure is not a option . please help. Posted in: #Coffee Room
Manish Goyal
Manish Goyal · Dec 27, 2010
Rank A2 - PRO
can you please explain with an example so that we can have more better idea?
kunaljd
kunaljd · Dec 27, 2010
Rank C3 - EXPERT
hello goyal,
CallableStatement cs2 = con.prepareCall("{call ADDITION(?,?,?)}");
cs2.registerOutParameter(3,java.sql.Types.INTEGER);
cs2.setInt(1,10);
cs2.setInt(2,25);
cs2.execute();
this is how we call a procedure of database using java.
in above statement only one procedure is called . but i have to call three procedure at same time.
Sachin Jain
Sachin Jain · Dec 28, 2010
Rank C2 - EXPERT
kunaljd
hello goyal,
CallableStatement cs2 = con.prepareCall("{call ADDITION(?,?,?)}");
cs2.registerOutParameter(3,java.sql.Types.INTEGER);
cs2.setInt(1,10);
cs2.setInt(2,25);
cs2.execute();
this is how we call a procedure of database using java.
in above statement only one procedure is called . but i have to call three procedure at same time.
You want to call these procedures using one statement still their execution will be sequential as i think.
So you can make another procedure which calls the three required procedures.
And then call the new procedure.
It think it may work....
Manish Goyal
Manish Goyal · Dec 29, 2010
Rank A2 - PRO
I think you can do so by using concept of Multi-threading in java
kunaljd
kunaljd · Dec 29, 2010
Rank C3 - EXPERT
Re: how to call three procedures in a single statement?

hi goyal,

do you know how to use multithreading to call three procedures?
if yes then please share your your knowlege.

You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up