All pastes #444944 Raw Edit

Stuff

public text v1 · immutable
·published 2007-04-17 16:38 UTC
rendered paste body
the procedure creation:
***********************


DELIMITER $$

DROP PROCEDURE IF EXISTS `prepaga`.`p1`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`( la varchar(20), ls varchar(20))
BEGIN
delete from b_cuit_cuil_aportes
	       	where lotes_aportes=la and lotes_subsidios=ls;
END$$

DELIMITER ;

the result:
***********

Error Code : 1267
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
(0 ms taken)

when i do call p1 ('50,51','111');