Re: DROP tables in PL/SQL

On 2005-11-29, Fabrizio Magni <fabrizio.magni_at_mycontinent.com> wrote:
> Try with:
>
> execute immediate 'drop table xxx';

Of course, this will fail if there is a table having a foreign key to xxx.

And yes, as others pointed out, it is very questionable to create and drop table in procedures.

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/