Re: Disable a trigger in a procedure

From: Andrew Babb <andrewb_at_mail.com>
Date: Wed, 21 Apr 1999 22:52:09 +0800
Message-ID: <371DE619.967112CE@mail.com>

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 Wed Apr 21 1999 - 09:52:09 CDT