How about creating a job (in the job queue) to execute the 'create user
procedure' and having your trigger, trigger the execution of the job in the
queue.
You can do this, by creating a job with the next date attribute as a date way
in the future and the job's interval set to a very long time. Your trigger
will use dbms_job.change to change the next_date to sysdate and the job will
execute.
This will work because dbms_job.change doesn't do a commit. When you commit
the insert, the job queue will see the new schedule and execute the procedure.
Chaim
Received on Wed May 24 2000 - 11:56:36 CDT
