oracle剔除表的存储过程

oracle删除表的存储过程

create or replace procedure PROC_dropTable(tabName in varchar2)as   tableName user_tables.table_name%type;    mycount number(10);  begin    tableName:= tabName;    SELECT COUNT(*) INTO mycount FROM user_tables WHERE TABLE_NAME = tableName ;    if mycount>0 then       execute immediate 'DROP TABLE '||tableName;    end if;  end;