-
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.0
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a
member of our community. Consider creating an
account or login.
Replies
-
Member • Dec 27, 2010
can you please explain with an example so that we can have more better idea?Are you sure? This action cannot be undone. -
Member • 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.Are you sure? This action cannot be undone. -
Member • Dec 27, 2010
You want to call these procedures using one statement still their execution will be sequential as i think.kunaljdhello 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.
So you can make another procedure which calls the three required procedures.
And then call the new procedure.
It think it may work....Are you sure? This action cannot be undone. -
Member • Dec 28, 2010
I think you can do so by using concept of Multi-threading in javaAre you sure? This action cannot be undone. -
Member • 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.Are you sure? This action cannot be undone.