Re: Using Oracl DDL-Statements in Procedures/Triggers on V. 7.3.2.2 and higher

Home -> Community -> Usenet -> c.d.o.server -> Re: Using Oracl DDL-Statements in Procedures/Triggers on V. 7.3.2.2 and higher

From: <michael_bialik_at_my-deja.com>
Date: Thu, 30 Sep 1999 20:39:36 GMT
Message-ID: <7t0hq6$jpv$1@nnrp1.deja.com>

In article <7sv6fo$knq$1_at_news.uk.ibm.com>, "Stein Andersen" <stein.andersen_at_no.ibm.com> wrote:
> We are making an application where we want to be able to create
synonyms,
> tables and indexes
> on the fly from triggers and procedures. Does anybody know how this
may be
> done in an basic
> Oracle installation, or if there are any packages we may install to
give us
> this functionality.
> -------------
> Stein Andersen
>

Hi.
You can issue DDL statements from Oracle stored proc. Look for DBMS_SQL package ( if you are working with Oracle 7.x, 8.0 ). Use "native dynamic sql" with 8i. You are not supposed to execute such commands from triggers, because DDL statements implicitly COMMITs.

Michael.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 15:39:36 CDT