Re: "Create Table" in Stored Procedure
From: Andrew Zitelli <zitelli_at_tus.ssi1.com>
Date: 1995/11/07
Message-ID: <47obp3$6b_at_atlas.tus.ssi1.com>#1/1
Date: 1995/11/07
Message-ID: <47obp3$6b_at_atlas.tus.ssi1.com>#1/1
skannan_at_cardinal.fs.com ( S. Kannan) wrote:
> Anita M. Wilcox (uplink_at_uplinktech.com) wrote:
>> <SNIP>
>> Is there any way to create and destroy tables within PL/SQL?
>
> If you are using Oracle 7.1 and above, there is a package called
> DBMS_SQL. This package will help you do what you want. However,
> like any other DDL statement, running DBMS_SQL with a DDL statement
> will also cause an implicit commit. Hope this helps.
As an added comment, please note that Oracle7 TRIGGERS may not execute commits or rollbacks. This means that stored procedures or functions executing DDL statements, cannot be called by triggers. Received on Tue Nov 07 1995 - 00:00:00 CET