Re: Disable Trigger in Stored Proc

Scott Metro wrote:
>
> 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)

try to use dynamic sql (buildin-package dbms_sql) good luck Received on Fri Mar 21 1997 - 00:00:00 CET