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.myexception.cn/oracle-develop/177537.html