Re: Disable Trigger in Stored Proc
From: L120bj <l120bj_at_aol.com>
Date: 1997/03/20
Message-ID: <19970320090701.EAA23492_at_ladder01.news.aol.com>#1/1
Subject: Disable Trigger in Stored Proc
From: "Scott Metro" <smetro_at_world.std.com> Date: Wed, 19 Mar 1997 19:48:18 GMT
Message-ID: <01bc349e$4a307ca0$0f02000a_at_patriots>
Date: 1997/03/20
Message-ID: <19970320090701.EAA23492_at_ladder01.news.aol.com>#1/1
You will have to call the DBMS_SQL package to execute DDL within a stored procedure, check the Application Developers guide for information.
Hope this helps
Rob
Subject: Disable Trigger in Stored Proc
From: "Scott Metro" <smetro_at_world.std.com> Date: Wed, 19 Mar 1997 19:48:18 GMT
Message-ID: <01bc349e$4a307ca0$0f02000a_at_patriots>
[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;
[Quoted] Any help would be greatly appreciated.
Thanks,
nospam_smetro_at_world.std.com
[Quoted] (Take out the "nospam_" before using the address)
Received on Thu Mar 20 1997 - 00:00:00 CET