oracle存储过程

create or replace procedure backup_logs_sp(status_flag out number) AS
BEGIN
insert into tablename1 select * from tablename2 where tablename2.create_time < trunc(sysdate-7);
delete from tablename2  where tablename2.create_time < trunc(sysdate-7);
COMMIT;
status_flag:=0;
Exception
	WHEN OTHERS THEN
	  status_flag:=1;
		ROLLBACK;
END backup_logs_sp;

主要目的是将插入和删除写在一个事务中