Re: How to prevent trigger recursive?

I know the difference between DDL and DML. But I haven't other way to prevent the action trigger again in case the trigger handling will raise up itself
again.

I have no alternative to do this trying.

Sybrand Bakker wrote:

> 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:37:26 CST