STABLE-3.0/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/mysql/create-update-sp.sql

CREATE PROCEDURE cayenne_tst_upd_proc (IN p1 DECIMAL) 
BEGIN
     UPDATE PAINTING SET ESTIMATED_PRICE = ESTIMATED_PRICE * 2
        WHERE ESTIMATED_PRICE < p1;
END