Yes. Look at the DBMS_SQL package.
In article <359a2f9c.6517281_at_news.iol.ie>, bwalsh_at_storm.ie says...
>
>Is it possible to drop a table from a stored procedure
>
>Here is what I'm trying to do (in Oracle 7.3)
>
>create or replace procedure tabledrop
>as
>begin
> drop table demo.test;
> return;
>end;
>
>The error I get is
>
>PLS-00103: Encountered the symbol "DROP" when expecting one of the
>following: begin desclare exit for goto if loop mod null pragma raise
>return select update while <an identifier> <a
>double-quoted-identifier> <a bind variable> <a single quoted SQL
>string> << close delete fetch lock insert open rollback savepoint set
>sql commit
>
>brendan
>---------------------
>Brendan Walsh
>Storm Technology Ltd.
>bwalsh_at_storm.ie
Received on Thu Jul 02 1998 - 11:54:35 CDT
