Re: PL/SQL and DDL

From: Bernard Antonuk <bantonuk_at_grtadv.shl.com>
Date: 1997/06/25
Message-ID: <33B1B7EC.461D@grtadv.shl.com>#1/1

Jamie Keir wrote:
>
> Tri Phan wrote in article <33B02C9D.2BEB_at_bdm.com>...
> >Hello,
> >
> >When using PL/SQL or built-in Oracle packages within store procedures
> >and packages, is there a way for me to use such DDL statements as
> >Create/Drop Table, Create/Drop Synonym, and Alter Table.
> >
> >Tri
> >
>
> There's a package called DBMS_SQL which you can use to do this. The
> DBMS_DDL package
> only seems to have a couple of procedures whach aren't tremendously
> useful.
>
> Jamie Keir

We're using Steven's Feuerstein PL/Vision library on our project. This set of Oracle building blocks includes tools to use DDL from whithin PL/SQL which are a lot more useful than the default toolset.

Cheers
Bernard Received on Wed Jun 25 1997 - 00:00:00 CDT