Re: Drop table/view
Date: 1996/12/12
Message-ID: <01bbe7b9$be5d4450$0100007f_at_otis>#1/1
Data definition language (DDL) is not supported in vanilla PL/SQL. You need
to check out the DBMS_SQL package.
This package allows PL/SQL to execute DDL & DML dynamically at run-time.
Guido vd Zweerde <GVDZ_at_dlep1.itg.ti.com> wrote in article
<01bbe74d$600ec7a0$77025982_at_civ002119.civ.utwente.nl>...
> I'm trying to write a PL/SQL procedure to drop tables/views. The purpose
is
> to drop
> only when the object exists. I've already written a PL/SQL block to check
> if the object
> exists, but when it exists and I tell it to drop the object it gives the
> next PL/SQL error message:
> PLS-00103 Encountered the symbol "DROP" when expecting one of the
> following:
> begin declare end exception exit for goto if loop mod null
> pragma raise return select update while <an identifier> etc.
Received on Thu Dec 12 1996 - 00:00:00 CET