Re: PL/SQL and DDL

From: Jamie Keir <jkerr_at_jameswatt.ac.uk>
Date: 1997/06/25
Message-ID: <5or37s$o1r@flex.uunet.pipex.com>#1/1

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 Received on Wed Jun 25 1997 - 00:00:00 CDT