how to call a three procedures in a single statement?

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.

can you please explain with an example so that we can have more better idea?

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.

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....

I think you can do so by using concept of Multi-threading in java

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.