how to call a three procedures in a single statement?

@kunaljd-worvpG • Oct 22, 2024

Oct 22, 2024

2.0K

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.

Like 0 Replies 5

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Manish Goyal

@manish-r2Hoep • Dec 27, 2010

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

@kunaljd-worvpG • 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.
0
Sachin Jain

@sachin-0wuUmc • Dec 27, 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....
0
Manish Goyal

@manish-r2Hoep • Dec 28, 2010

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

@kunaljd-worvpG • 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.
0