Can you use a PL/SQL procedure to create a table?

Subject line pretty much says it all...

I need to be able to create several different types of tables on demand from within an application. Instead of using a CREATE TABLE sql command, followed by a series of CREATE INDEX commands etc, I would like to have the code encapsulated within a stored proc, which can then be called as needed.

I can not find anything in the docs I have as to how or even if it can be done.

Any suggestions?

Thanks.

Santanu Received on Thu Mar 11 1999 - 14:14:37 CST