store procedure call

[maurixgr]

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

[Nepomuk]

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

[maurixgr]

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

[JosAH]

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

Have a look at the CallableStateme nt interface (it extends the PreparedStateme nt interface)

kind regards,

Jos

[maurixgr]

resolved

Thanks you for your help.

mega