triggers question

Hi,

I have a alter trigger at the schema level and want to be able to create a trigger on the same table dynamically. I am using autonomous transactions to allow commit operations inside a trigger however I have a locking problem when altering the table and then at the same time trying to create a trigger on the same table. Is there a way around this? I was thinking of using DBMS_JOB to schedule the trigger creation at a later time but this would be the optimal solution.

Any helo is appreciated.

Thanks

Ketan Received on Sun Aug 06 2000 - 00:00:00 CDT