Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [03-2008 Date Index] [Date Next] || [Thread Prev] [03-2008 Thread Index] [Thread Next]

Re: AW: Creating a trigger inside a trigger

  • From: Peter Teoh <htmldeveloper@xxxxxxxxx>
  • To: torsten.rosenwald@xxxxxx
  • Date: Tue, 04 Mar 2008 16:54:11 +0800
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






[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.