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; 

我的异常网推荐解决方案：oracle存储过程,http://www.aiyiweb.com/oracle-develop/177537.html