Re: can't create table from package

>What is evil & wrong is doing DDL from inside PL/SQL.
>
>I wish that Oracle never had created EXECUTE IMMEDIATE to allow such
>nonsense.

DDL in PL/SQL has its uses. How else are you going to write an installation script for database objects which is

1. safely re-runnable
2. is not allowed to throw any exceptions about already existing objects on re-run

Don't have EXCEPTION or IF in pure SQL... Received on Thu Dec 13 2007 - 00:51:11 CST