Re: Triggers and create user

Hi,

If you're using version 7.1 or later of the Oracle RDBMS, you can use the DBMS_SQL package to accomplish your "create user" task. This package allows you to execute dynamic SQL; additionally, it will allow you to issue DDL statements.

When issuing DDL through DBMS_SQL, you'll have to keep two things in mind:  first, an implicit commit will occur when each statement is executed; secondly, the warning taken from the package specification speaks for itself.

• WARNING: Using the package to dynamically execute DDL statements can
• results in the program hanging. For example, a call to a procedure in a
• package will result in the package being locked until the execution
• returns to the user side. Any operation that results in a conflicting
• lock, such as dynamically trying to drop the package, before the first
• lock is released will result in a hang.

Probably not going to occur but worth noting.

I hope this helps.

Thom Marikle

"Why do they call it tourist season if you can't shoot them?" Received on Wed Sep 27 1995 - 00:00:00 CET