Calling a MySQL stored procedure from a web service....

Im trying to use this stored procedure:

-- --------------------------------------------------------------------------------
-- Routine DDL
-- Note: comments before and after the routine body will not be stored by the server
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `linkacorte`(vid_pedido int(11), vid_producto int(11),vtiempo varchar(50),vid_pastelero int(11),
   vcorte varchar(200),vnum int(2))
begin
declare campo varchar(20);
DECLARE EXIT HANDLER FOR SQLSTATE '42000'
    SELECT 'Ha introducido un campo incorrecto. Solo se permite 1,2 o 3';

if vnum=1 then
    set campo='programa_corte_1';
elseif vnum=2 then
    set campo='programa_corte_2';
elseif vnum=3 then
    set campo='programa_corte_3';
else
CALL raise_error;
end if;
set @sqltext=concat('UPDATE pedidos_productos SET ',campo,'=',vcorte,' WHERE id_pedido=',vid_pedido,
   ' AND id_producto=',vid_producto,' AND tiempo=',vtiempo,' AND id_pastelero=',vid_pastelero);
prepare stmt from @sqltext;
execute stmt;
deallocate prepare stmt;
commit;

end

Depending on which number I pass in vnum, it either updates column 'programa_corte_1' 'programa_corte_2' or 'programa_corte_3'. It for some reason does nothing and Im thinking that it is a Java problem because I THINK the MySQL commands are correct....

Hi
I edited your post to make some of the lines shorter, just so you know.
If it isn't working from java could you show us the java calls that aren't working?

so it does work when you call it from mysql?

and by not work does it return an exception or just do nothing?