Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor to drop all tables
You can't perform DDL in a PL/SQL block (create, drop, truncate etc.). You can
make use of the dbms_sql package to perform dynamic sql which should get around
your problem.
Alternatively, you could use SQL*Plus to create a 'drop' script which could then be run to drop all necessary tables.
Ed Received on Thu Jan 06 2000 - 15:44:15 CST
![]() |
![]() |