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.
Received on Wed May 24 2000 - 08:44:08 CDT
