all stored procedure with OUT parameter

popskie · #1 (**permalink**) 11-21-05, 22:59

hi,
How to call a mysql stored procedure with OUT parameter.
i.e.

Code:

create procedure spname (in par1 int,out part2 int)
begin
////
end

thanks,
POpskie

Chagh · #2 (**permalink**) 11-22-05, 07:05

hi,
you should define a session variable in mysql client and put it in the SPs parameter list and then select it.
e.g.

Code:

call spname(4, @a);
select @a;

and in another sp you should define an ordinary local variable and put it instead of your out prameter, then you can do any calculation you want with that variable.

goodluck
--Chagh

popskie · #3 (**permalink**) 11-22-05, 20:02

thanks chagh LOL. It works well.

Internet Services

Web Development

Digital Marketing

Consumer Tech