RE: Executing DDL from trigger

try using autonomous transaction
It will only commits your work in the trigger and then you will probably be able to use DBMS_SQL
If not then try native dynamic SQL

Jean

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jim Conboy
> Sent: mercredi 24 mai 2000 17:04
> To: Multiple recipients of list ORACLE-L
> Subject: Executing DDL from trigger
>
>
> Hi folks-
>
> I'm trying to simplify the process of creating a user account for
> a COTS package where I can't touch the code. There's some user
> configuration within the application, and of course there's
> creating the actual Oracle account. I created an insert trigger
> for the main user configuration table and used DBMS_SQL to
> execute a CREATE USER statement. The code works fine as a stored
> procedure, but as a trigger I get an error 4092 that commit not
> allowed in a trigger, presumably because of the CREATE USER DDL.
> I tried having the trigger execute the procedure but got the same
> error - actually I'd be disturbed if it didn't! I'm not looking
> for anything too involved here because a script will do the trick
> fine, just wondering if anybody has a simple suggestion to make
> this work. Thanks.
>
> Jim
>
>
> --
> Author: Jim Conboy
> INET: Jim.Conboy_at_trw.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 24 2000 - 10:20:58 CDT