Disable Trigger in Stored Proc
From: Scott Metro <smetro_at_world.std.com>
Date: 1997/03/19
Message-ID: <01bc349e$4a307ca0$0f02000a_at_patriots>#1/1
Date: 1997/03/19
Message-ID: <01bc349e$4a307ca0$0f02000a_at_patriots>#1/1
[Quoted] [Quoted] I have an application that needs to disable triggers before it runs a particular process. Is it possible to write a stored procedure that can disable triggers. I have tried, using the following syntax, but it compiles with errors:
CREATE OR REPLACE PROCEDURE SP_TEST AS
BEGIN
ALTER TABLE TEST2 DISABLE ALL TRIGGERS;
END;
Any help would be greatly appreciated.
Thanks,
nospam_smetro_at_world.std.com
(Take out the "nospam_" before using the address)
Received on Wed Mar 19 1997 - 00:00:00 CET