Re: Updating a field in a stored procedure

[Geo Barreros]

Here is the complete procedure, I figure it might help to see if I am doing something wrong besides the sql statement.

DELIMITER $$
DROP PROCEDURE IF EXISTS DuplicateProduct$$
CREATE PROCEDURE DuplicateProduct()
BEGIN

UPDATE oc_product_description_temp SET product_id=(SELECT product_id FROM oc_product WHERE sku='sku19');


END$$
DELIMITER ;

The Select statement returns only a single product_id value. The UPDATE statement updates multiple rows, but don't think that is the problem because I replaced the Select statement with a statci value and it worked without a problem. Again, this sql statement runs flawlessly outside the store procedure.