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

From: Giorgio <G.Sorbara_at_fake.soft.it>
Date: Thu, 18 Mar 1999 16:23:33 +0100
Message-ID: <7cr733$gbq$1@fe1.cs.interbusiness.it>

Hi,

all you need is the "dbms_sql" package...:) pretty easy

Bye..

Santanu Lahiri wrote in message
<7c9862$no5$1_at_charm.magnus.acs.ohio-state.edu>...
>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 18 1999 - 09:23:33 CST