Re: How to prevent trigger recursive?

On Thu, 22 Feb 2001 14:21:42 +0800, Diviner <diviner_at_hknet.com> wrote:

>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.
alter trigger is DDL, so you need execute immediate or dbms_sql to process this.
Do you think this is going to work? Do you want to disable the trigger you are calling at the same moment?

Please try to read the Oracle Application Developers Guide. Why do you think you can do without?

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Feb 22 2001 - 01:02:38 CST