Re: Disabling triggers

Open the file and write the following script and execute.

declare
p integer;
k integer;
begin
p:=dbms_sql.open_cursor;
dbms_sql.parse(p,'alter trigger trig_trans disable',dbms_sql.native); k:=dbms_sql.execute(p);
dbms_sql.close_cursor(p);
end;

Regards
shailaja.

Sam Jordan <sjo_at_spin.ch> wrote in message news:37651219.F9F608EF_at_spin.ch...
> Hi
>
> Is there any way to disable a trigger programmatically, for example
> in a stored procedure? I'd like to disable a trigger, perform some
> SQL stuff and reenable it afterwards. For other statements the
> trigger shouldn't be deactivated.
>
> bye
> --
> Sam Jordan
Received on Tue Jun 15 1999 - 16:55:41 CDT