Re: Disable a trigger in a procedure

Thanks Andrew,
it works with the DBMS_SQL Package.

Regards
Thomas

Andrew Babb wrote:

> Thomas,
>
> The ALTER TRIGGER command is a DDL operation and as such cannot be issued
> directly within a Procedure. Instead the operation needs to be wrapped
> inside a call to the DBMS_SQL package.
>
> There have been a number of DBMS_SQL related discussions on the news groups
> recently.
>
> Rgds
> Andrew
>
> Thomas Staack wrote:
>
> > Hello,
> >
> > Altering the status of a trigger in a procedure causes a compile error
> > (PLS-00103). The statement is
> > "ALTER TRIGGER it_schiffe DISABLE;".
> > Executing the same statement directly in the SQL Worksheet works.
> >
> > Who can help me? I want to change the status temporarily within a stored
> > procedure.
> >
> > Thanks in advance.
> > Regards
> >
> > Thomas
Received on Thu Apr 22 1999 - 08:56:56 CDT