Drop Table in PLSQL Script
From: August <august.pasimio_at_quest.com>
Date: 25 Jun 2002 10:37:27 -0700
Message-ID: <890bf4f6.0206250937.268d301_at_posting.google.com>
Date: 25 Jun 2002 10:37:27 -0700
Message-ID: <890bf4f6.0206250937.268d301_at_posting.google.com>
Hi, All -
When I run it, I get this error:
Is drop table not allowed in a plsql script?
SQL> _at_drop_test_tables
drop table my_table_name;
*
ERROR at line 12:
ORA-06550: line 12, column 3:
PLS-00103: Encountered the symbol "DROP" when expecting one of the following:
begin declare end exit for goto if loop mod null pragma raise
return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
<a single-quoted SQL string>
Thanks in advance,
August
SQL>
Received on Tue Jun 25 2002 - 19:37:27 CEST