存储过程脚本代码如下:
create or replace procedure "bak_Info_Pro"
is
/*--str_sql varchar2(500);*/
begin
insert into t_hp_tips_bak select * from t_hp_tips t where t.invalid_date<sysdate; /*判断是否插入备份表成功,若成功则删除原表中过期记录
--execurte immediate str_sql;*/
delete from t_hp_tips t where t.invalid_date<sysdate;
commit;
Exception
when others then
rollback;
end bak_Info_Pro;错误提示如下:PROCEDURE HUIFU2.BAK_INFO_PRO 编译错误错误:PLS-00103: 出现符号 "INSERT"在需要下列之一时:
( ; is with authid as
cluster compress order using compiled wrapped external
deterministic parallel_enable pipelined
行:5
文本:str_sql:='insert into t_hp_tips_bak select * from t_hp_tips t where t.invalid_date<sysdate';
create or replace procedure "bak_Info_Pro"
is
/*--str_sql varchar2(500);*/
begin
insert into t_hp_tips_bak select * from t_hp_tips t where t.invalid_date<sysdate; /*判断是否插入备份表成功,若成功则删除原表中过期记录
--execurte immediate str_sql;*/
delete from t_hp_tips t where t.invalid_date<sysdate;
commit;
Exception
when others then
rollback;
end bak_Info_Pro;错误提示如下:PROCEDURE HUIFU2.BAK_INFO_PRO 编译错误错误:PLS-00103: 出现符号 "INSERT"在需要下列之一时:
( ; is with authid as
cluster compress order using compiled wrapped external
deterministic parallel_enable pipelined
行:5
文本:str_sql:='insert into t_hp_tips_bak select * from t_hp_tips t where t.invalid_date<sysdate';
/*--str_sql varchar2(500);*/
begin
insert into t_hp_tips_bak
select * from t_hp_tips t where t.invalid_date < sysdate;
/*判断是否插入备份表成功,若成功则删除原表中过期记录
--execurte immediate str_sql;*/ delete from t_hp_tips t where t.invalid_date < sysdate;
commit;
Exception
when others then
rollback;
end bak_Info_Pro;