Question

PL/SQL运行报错

CREATE OR REPLACE PROCEDURE CREATE_TABLE
(
tablename in varchar2
)

AS
tablecount int:=0;
BEGIN
select count(1) into tablecount from all_tables where TABLE_NAME=tablename AND OWNER='ZXIN';
if (tablecount=0) then
begin
drop table tablename;

end;
end if;
end;

删除if那段就没问题 要不然就报

错误：PLS-00103: Encountered the symbol "DROP" when expecting one of the following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
行：12
文本：drop table tablename;
删除drop table tablename;又报end;错误

Answer 1

用这样
execute immediate 'drop table ' || tablename

追问

为什么我删除了drop table tablename;会报end的错误

追答

tablename 是一个字符串

你相当于这样执行 drop table 'myTableName'

Answer 2

看到这个好熟悉ZXIN