谁帮我看一下这个oracle过程,有什么问题
CREATE OR REPLACE PROCEDURE hm_gx_zlwz @cywdm NUMBER(10) AS
BEGIN
CREATE table lsb AS SELECT * FROM yw_sxcd WHERE ywdm=@cywdm
UPDATE lsb SET zlwz='8'
DELETE FROM yw_sxcd WHERE ywdm=@cywdm
insert into yw_sxcd SELECT * from lsb
drop table lsb
END