insert into care.his_info_user_vip_level select a.*,to_char(add_months(sysdate,-1),yyyymm),sysdate from care.info_user_vip_level a where acct_monthto_char(add_months(sysdate,-1),YYYYMM) and vip_level =P14; commit; update care.info_user_vip_level set last_level=vip_level,vip_level = PT,assess_date = sysdate,flag=N,acct_month=to_char(add_months(sysdate,-1),YYYYMM),card_number=null where acct_monthto_char(add_months(sysdate,-1),YYYYMM) and vip_level =P14******************************************PROCEDURE EveryMonthAssess(out_err out number)里面都是一些插入和修改语句,F9 和test后既不报错,也没见test页面有什么变化