CREATE DEFINER=`root`@`localhost` PROCEDURE `new_procedure`()
BEGIN

DECLARE  STR_IBLOCK_ELEMENT_ID Integer;
DECLARE  STR_ID Integer;
DECLARE  STR_VALUE double;
DECLARE  TXT_VALUE varchar(20);
Declare done integer default 0;
DECLARE curs CURSOR FOR SELECT 
    IBLOCK_ELEMENT_ID, VALUE
FROM
    bitrix_66.b_iblock_element_property
WHERE
    IBLOCK_PROPERTY_ID = '310' ;
    
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;
 
 Open curs;



REPEAT

FETCH curs INTO STR_IBLOCK_ELEMENT_ID , STR_VALUE;
 IF NOT done THEN  
 
set	STR_VALUE :=  STR_VALUE * 5;

/*set	TXT_VALUE := concat(convert(STR_VALUE,char), ' руб');*/



UPDATE bitrix_66.b_iblock_element_property VALUE 
SET 
    VALUE = STR_VALUE
WHERE
    IBLOCK_PROPERTY_ID = '173'
        AND IBLOCK_ELEMENT_ID = STR_IBLOCK_ELEMENT_ID;
        
end if;
UNTIL done END REPEAT;


Close curs;


END