DDL Statements in PL/SQL !?!

How does one go about performing administrative tasks (like removing all sequences or indexes) in a iterative fashion without spooling out the contents of a query into a file a then creating a script to execute?

For example. I want to delete all the sequences for a single user and then reset them with a higher value. I can easily determine the names of the all the sequences, I can write a query that will return to me all the tables with primary keys and the maximum values for those columns but I can not write a PL/SQL block that will identify the sequences, identify the columns that they are used for, DROP the sequences (DDL) statement, and then create and rename the sequence for each column set at the column max value + 1000 ...

Why can't I execute DDL in PL/SQL and is there a better way to do this programmatically with out a lot of script writing? I want to pass a PL/SQL block a user name and have it do all the rest.

Any information would be appreciated. Please contact me directly at pveenstra_at_mjharden.com or pcgv1_at_ibm.net.

Merci,

Peter

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun May 02 1999 - 22:51:43 CDT