View Feed
group-icon
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12889 Members
Join this group to post and comment.
kunaljd
kunaljd • Dec 27, 2010

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?
kunaljd
kunaljd • Dec 27, 2010
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
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
kunaljd
kunaljd • Dec 29, 2010
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.

Share this content on your social channels -