declare lup dynamic procedure for sqlsa;msql="update mma set stock_gd = stock_gd - 10 where m_id like '"+mlike+"%'"prepare sqlsa from :msql;execute dynamic lup;close lup;