Re: Drop Table from Stored Procedure

>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

Use the DBMS_SQL package to build, parse and execute the SQL statement.

Dan Hekimian-Williams Received on Wed Jul 01 1998 - 20:13:54 CDT