Re: Bypassing trigger on tables

On Wed, 10 May 2000 19:31:19 +0200, "Gertjan" <gr_at_compexbv.nl> wrote:

>For one of our customers we have a table that holds a trigger which copies
>the contents of the record that gets updated to an archiving table.
>
>Is there anyway I can update this table and NOT let the trigger go off? I
>want to update the table from pl/sql.
>
>

You could sandwich your PL/SQL table between a couple of procedures using Dynamic SQL to disable then enable the trigger. You'd need to be sure that nobody else could carry out updates you do want to capture when your job is running. Received on Wed May 10 2000 - 00:00:00 CDT