Triggers cannot be modified. They must be dropped and then
created again according to the new definitions you require.
About this task
A trigger object can be dropped using the DROP TRIGGER statement,
but this procedure will cause dependent packages to be marked invalid,
as follows:
- If an update trigger without an explicit column list is dropped,
then packages with an update usage on the target table are invalidated.
- If an update trigger with a column list is dropped, then packages
with update usage on the target table are only invalidated if the
package also had an update usage on at least one column in the column-name
list of the CREATE TRIGGER statement.
- If an insert trigger is dropped, packages that have an insert
usage on the target table are invalidated.
- If a delete trigger is dropped, packages that have a delete usage
on the target table are invalidated.
A package remains invalid until the application program is
explicitly bound or rebound, or it is run and the database manager
automatically rebinds it.