store procedure call

Hi:

I´m calling a store procedure inside another store procedure and I have two problems

create sp1(in variable int)
begin

call sp2(variable)
call sp3(variable)
call sp4(variable)
end

the first thing is :

If I call each sp alone it works fine but if I call the sp1 it does´t work and no error messages are reported.


The second thing is:

How can I write a log with the value of the variable received by each sp?


Kind regards

mega

re: store procedure call

Hi Mega and welcome to bytes!

I'm not quite sure what that code should do, but it's certainly not Java. Could it be JavaScript maybe? Or something completely different? If you tell us, we'll move this thread to wherever it belongs.

Also, could you describe the problem in more detail, so that the experts in the forum this will be moved to can help you more easily?

Greetings,
Nepomuk

re: store procedure call

Hi Nepomuk

Thnaks you for your reply. I find a mistake in my technique and resolved the problem.

I´m using sql procedures.


I have a question:

how can I call a procedure that has an out parameter? I need to capture the out parameter in a variable.


Kind regards

Mega

re: store procedure call

Have a look at the CallableStatement interface (it extends the PreparedStatement interface)

kind regards,

Jos

re: store procedure call

Thanks you for your help.

mega