Drop Table from Stored Procedure

From: Brendan Walsh <bwalsh_at_storm.ie>
Date: Wed, 01 Jul 1998 15:16:39 GMT
Message-ID: <359a2f9c.6517281@news.iol.ie>

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 Wed Jul 01 1998 - 10:16:39 CDT