执行提示错误:表不存在
四川张三丰 2019-05-16 12:39:43
declare
vrowcount number;
vtotal number :=0;
v_createSQL varchar2(2000);
cn number:=0;
begin
v_createSQL :='create table TBSJ_LOG
(
id NUMBER(10),
pr_name VARCHAR2(50),
table_name VARCHAR2(50),
pcdm VARCHAR2(14),
message VARCHAR2(200),
step NUMBER(3),
update_time DATE default sysdate
)';
select count(1) into cn from all_tables where TABLE_NAME = 'TBSJ_LOG' and OWNER='YLH';
if cn = 0 then
execute immediate v_createSQL;
end if;
for i in 1..15001/5000 + 1 loop
delete from ypml_x_2018_01_cs where rownum<=5000;
vrowcount := sql%rowcount;
vtotal := vtotal + 1;
insert into TBSJ_LOG
(message, update_time)
values
(to_char(vrowcount) || '数据已删除', sysdate);
commit;
end loop;
end;
我在执行这语句的时候,提示TBSJ_LOG 不存在,但是前面有创建TBSJ_LOG的语句。请高手帮看看?