Home » Developer & Programmer » Forms » Compile Triggers
Compile Triggers [message #78739] Wed, 13 March 2002 09:35 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
Hello all,

I am about to delete a bunch of code out of a whole pile of triggers (audit inserts into history tables). I want to leave all the other code in the triggers and then recompile them... How could I write a script to recompile the triggers... I know that there is ALTER PROCEDURE name COMPILE; or ALTER FUNCTION name COMPILE; But I can't seem to find ALTER TRIGGER name COMPILE;....SUGGESTIONS?

T
Re: Compile Triggers [message #78746 is a reply to message #78739] Wed, 13 March 2002 23:52 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
when u delete the code from the trigger u have to run the code again ,at this time it will automatically compiled.

e.g.
old trigger
----------
create or replace trigger....
...
begin
line1;
line2;
end;

let us take line2 out.so

new trigger
-----------

create or replace trigger....
...
begin
line1;
end;

to make this changes to database u have to run the above code, at that time it will automatically compiled.
Previous Topic: frm-40734
Next Topic: *** Showing message when SPACE BAR pressed , how to ***
Goto Forum:
  


Current Time: Thu Feb 02 05:52:17 CST 2023