DDL in PL/SQL

From: <dennishancy_at_eaton.com>
Date: Tue, 01 Jun 1999 20:10:03 GMT
Message-ID: <7j1enh$hqa$1@nnrp2.deja.com>

I have a PL/SQL block that looks like the following:

---

declare
<some variables declared>

begin
  drop table x;
  create table x
  ( etc, etc, etc...);
<some DML statements>

end;

---

When I try to run this, it complains about the "drop" statement. If I comment that out, along with the "create" statement, all goes well. Can I not use DDL statements in a PL/SQL block like this? Thanks..

Dennis Hancy
Eaton Corporation
Cleveland, OH

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 01 1999 - 15:10:03 CDT