How to prevent trigger recursive?

From: Diviner <diviner_at_hknet.com>
Date: Thu, 22 Feb 2001 14:21:42 +0800
Message-ID: <3A94AFF6.E5ADD7B1@hknet.com>

I tried to place a Disable clause inside but failed to compile, like this:

---

   create or replace trigger tri_RenameDir

      before Update on DocIndex
   begin

      alter trigger tri_RenameDir disable;
      ....
      alter trigger tri_RenameDir enable;

   end;

---

So how to do that? Thank you very much.

--
Best regards,
Diviner.

Received on Thu Feb 22 2001 - 00:21:42 CST