declare
i number(4);
v_sql varchar2(512);
begin
select count(*) into i from user_all_tables where table_name = 'Grid_Boundary_point';
if i > 0 then
execute immediate 'drop table Grid_Boundary_point';
commit;
end if;
v_sql := 'create table Grid_Boundary_point(a number)';
execute immediate v_sql;
end;
这行 execute immediate v_sql; 报错name is already used by an existing object
这是怎么回事?怎么解决?
i number(4);
v_sql varchar2(512);
begin
select count(*) into i from user_all_tables where table_name = 'Grid_Boundary_point';
if i > 0 then
execute immediate 'drop table Grid_Boundary_point';
commit;
end if;
v_sql := 'create table Grid_Boundary_point(a number)';
execute immediate v_sql;
end;
这行 execute immediate v_sql; 报错name is already used by an existing object
这是怎么回事?怎么解决?
if i>0 then
execute immediate 'drop table Grid_Boundary_point cascade constraints';
end if;