Re: PL/SQL and DDL

From: Lawrence Simela <lsimela_at_cix.compulink.co.uk>
Date: 1997/06/29
Message-ID: <ECJtrL.n25@cix.compulink.co.uk>#1/1

>>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

Yes, DDL statements can only be issued using dynamic SQL. Use the DBMS_SQL package to execute SQL statements dynamically at runtime.

Lawrence Simela
Mahalini Consulting Limited. Received on Sun Jun 29 1997 - 00:00:00 CDT