Re: Drop table/view

Guido vd Zweerde wrote:
>
> 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:

  DROP is a DDL statement. You need use DBMS_SQL to deal with it.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841