MySQL continue handler for 1329 not working.please help..the SP hangs

[VamsiKrishnaP]

DELIMITER $$

USE `tsmakersmark`$$

DROP PROCEDURE IF EXISTS `LoadProductImages`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `LoadProductImages`(pmerchant_id VARCHAR(200))
BEGIN

DECLARE int_no_of_rec VARCHAR(30);
DECLARE Retdonep INT DEFAULT 0;
DECLARE no_of_rec INT DEFAULT 0;
DECLARE RetCsrSTYLE_SID VARCHAR(20);
DECLARE RetCsrITEM_SID VARCHAR(20);
DECLARE RetCsrDESCRIPTION4 VARCHAR(20);
DECLARE prodid INT(10);
DECLARE errormessage VARCHAR(200);
DECLARE RetCsrProductStyle CURSOR FOR SELECT DISTINCT STYLE_SID FROM retailprotoweb.osinvn_sbs WHERE MERCHANTID=pmerchant_id ;
DECLARE CONTINUE HANDLER FOR 02000 SET Retdonep = 1;
DECLARE CONTINUE HANDLER FOR 1329 SET @error=1;

SET @error=0;

OPEN RetCsrProductStyle;
REPEAT

FETCH RetCsrProductStyle INTO RetCsrSTYLE_SID;



IF NOT Retdonep THEN



IF RetCsrSTYLE_SID IS NOT NULL AND RetCsrSTYLE_SID != '' THEN

-- select DESCRIPTION4 into RetCsrDESCRIPTION4 from retailprotoweb.osinvn_sbs WHERE STYLE_SID = RetCsrSTYLE_SID AND MERCHANTID=pmerchant_id;
/*
set no_of_rec = (SELECT 1 FROM retailprotoweb.osinvn_sbs osbs,retailprotoweb.osinvn_image oi WHERE osbs.ITEM_SID = oi.ITEM_SID AND IMAGE100 IS NOT NULL AND IMAGE300 IS NOT NULL AND osbs.MERCHANTID= pmerchant_id AND osbs.STYLE_SID = RetCsrSTYLE_SID LIMIT 0,1);
IF (@error>0) THEN
CASE @error
WHEN '1' THEN SET errormessage='No data found';

END CASE;
select 1;
-- INSERT INTO retailprotoweb.osdcserrorlog SELECT *,NOW(),errormessage FROM retailprotoweb.osdcs WHERE DCS_CODE=RetCsrDCSCODE;
END IF;
-- SET int_no_of_rec = (select * from ts_product);


if no_of_rec > 0 and no_of_rec is not null and no_of_rec!='' then

INSERT INTO tsmakersmark.mylogs(c1,c2,c3,c4) VALUES('no_of_rec',no_of_rec,RetCsrSTYLE_SID,'insi de if');

set RetCsrITEM_SID='';

SELECT oi.ITEM_SID INTO RetCsrITEM_SID FROM retailprotoweb.osinvn_sbs osbs,retailprotoweb.osinvn_image oi WHERE osbs.ITEM_SID = oi.ITEM_SID AND IMAGE100 IS NOT NULL AND IMAGE300 IS NOT NULL AND osbs.MERCHANTID= pmerchant_id AND osbs.STYLE_SID = RetCsrSTYLE_SID LIMIT 0,1;

-- INSERT INTO prestashop.mylogs(c2)VALUES(RetCsrDESCRIPTION4);



-- select getImageSID(RetCsrSTYLE_SID,pmerchant_id) into RetCsrITEM_SID;

IF RetCsrITEM_SID IS NOT NULL AND RetCsrITEM_SID != '' and RetCsrITEM_SID != 0 THEN

SET prodid = 0;
SET @pImgChk=0; -- Added Now
SET @pName=''; -- Added Now

SELECT id_product INTO prodid FROM ts_product WHERE reference = RetCsrSTYLE_SID ;

SELECT @pName:= NAME FROM ts_product_lang WHERE id_product = prodid AND id_lang = 1 ;

SELECT @pImgChk := id_image FROM ts_image WHERE id_product = prodid;

-- IF prodid IS NOT NULL AND prodid != "" THEN
IF prodid > 0 THEN -- added now

-- INSERT INTO prestashop.mylogs(c1,c2,c3,c4,c5)VALUES(RetCsrSTYL E_SID,RetCsrDESCRIPTION4,@pName,prodid,@ImageId);
-- INSERT INTO retailprotoweb.osinvn_image_mapping(ITEM_SID,STYLE _SID,Product_ID,ImageID,MERCHANTID,Date_Created,Da te_Updated)VALUES('',RetCsrSTYLE_SID,prodid,@Image Id,pmerchant_id,NOW(),NOW());


IF @pImgChk >0 THEN


SELECT 1;
UPDATE retailprotoweb.osinvn_image_mapping SET Date_Updated = NOW() WHERE STYLE_SID = RetCsrSTYLE_SID AND Product_ID = prodid AND ImageID = @ImageId AND MERCHANTID = pmerchant_id;

ELSE

INSERT INTO ts_image(id_product,POSITION,cover) VALUES(prodid,1,1);

SET @ImageId=''; -- Added Now

SELECT @ImageId := MAX(id_image) FROM ts_image; -- Fetch previously inserted Image Id.

INSERT INTO ts_image_lang(id_image,id_lang,legend) VALUES(@ImageId,1,@pName);

INSERT INTO retailprotoweb.osinvn_image_mapping(ITEM_SID,STYLE _SID,Product_ID,ImageID,MERCHANTID,Date_Created,Da te_Updated)VALUES(RetCsrITEM_SID,RetCsrSTYLE_SID,p rodid,@ImageId,pmerchant_id,NOW(),NOW());

END IF; -- for @pImgChl ..

END IF; -- for prodid
END IF; -- RetCsrITEM_SID

else -- no_or_rec
select 1;
end if; -- no_or_rec

*/

SELECT 1;

ELSE

SELECT 1;

END IF; -- end of RetCsrSTYLE_SID


END IF; -- end of retdone



UNTIL Retdonep END REPEAT;
CLOSE RetCsrProductStyle;


END$$

DELIMITER ;