ORACLE 存储过程不能用truncate table xxx
CREATE OR REPLACE PROCEDURE XM_MRP_YFKUWEI1 AS
/*
工作日每天0点30,要HOLD住研发仓(将F41021的批次状态码=E,条件F0005的研发库位);
*/
BEGIN
execute immediate 'TRUNCATE TABLE BAK_F41021_MRP';
INSERT INTO BAK_F41021_MRP select * from f41021 where lilocn like 'YF%' ;
COMMIT;
UPDATE F41021 SET LILOTS='E' WHERE LILOCN LIKE 'YF%';
COMMIT;
END;
CREATE OR REPLACE PROCEDURE XM_MRP_YFKUWEI1 AS
/*
工作日每天0点30,要HOLD住研发仓(将F41021的批次状态码=E,条件F0005的研发库位);
*/
BEGIN
execute immediate 'TRUNCATE TABLE BAK_F41021_MRP';
INSERT INTO BAK_F41021_MRP select * from f41021 where lilocn like 'YF%' ;
COMMIT;
UPDATE F41021 SET LILOTS='E' WHERE LILOCN LIKE 'YF%';
COMMIT;
END;