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;