oracle_存储过程_剔除数据表

oracle_存储过程_删除数据表

--用于删除数据表(via tablename)

create or replace procedure DropTable(tablename in varchar) is

ls_sql varchar2(4000);

v_count number;

v_tablename varchar2(400);

begin

? v_tablename:=upper(tablename);

? ?execute immediate 'drop table '||v_tablename;

? exception

? ? when others then

? ? ?rollback;

? ? ?null;

end DropTable;