Re: AW: Creating a trigger inside a trigger

Torsten Rosenwald wrote:
> Hi Peter,
>
> What might do the trick is scheduling a job in the startup trigger that
> creates the shutdown trigger.
>
> hth,
> Torsten.
>
>
>
>

Good idea, I tried exactly like that (some time back), thinking that stored procedure can create the trigger, so can the job. The job got triggered, but since it is running in the context of the trigger, it did not work either.

:-).

--
http://www.freelists.org/webpage/oracle-l