Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Executing DDL from trigger

Re: Executing DDL from trigger

From: Veera Prasad <vprasad_at_olf.com>
Date: Wed, 24 May 2000 11:51:39 -0400
Message-Id: <10507.106541@fatcity.com>


please ignore my earlier mail , I guess the autonomous transaction doesn't work for DDL's .sorry .....

Veera Prasad wrote:

> I am pretty sure we cannot use commit in triggers and DDL's are autocommit.
> try using autonomous transaction in trigger declaration part,
> or send me the trigger code , if it is ok with u, may be I may come up
> with better solution.
>
> Jim Conboy wrote:
>
> > 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).
>
> --
> Author: Veera Prasad
> INET: vprasad_at_olf.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:51:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US