A Creating a Database Trigger in the BMC Database

To create a database trigger for moving all deleted users from the SHR:People form to the SHR:DeletePeople form, perform the following steps:

1. Log in to SQL*Plus.

2. Copy the following script at the SQL prompt:

   CREATE or REPLACE TRIGGER trig1
   AFTER DELETE ON t57
   FOR EACH ROW
   BEGIN
   INSERT INTO t608
   (C1,C2,C3,C4,C5,C6,C7,C8,C102,C109,C115,C179,
   C100000106,C100000113,C100000120,C100000121,C100000122,
   C200000006,C200000007,C200000012,C230000009,C240000001,
   C240000003,C240000004,C240000005,C240000006,C240000007,
   C240000008,C240000009,C240000010,C240000011,C240000035,
   C240000036,C240000037,C240000038,C240000040V,C240000040C,
   C240000040D,C240000040USD,C240000040EUR,C240000040GBP,
   C240000040JPY,C240000041,C240000042,C260000000,C260000001,
   C260000002,C260000003,C260000004,C260000005,C260000006,
   C260000008,C260000009,C260000010,C260000026,C261000002,
   C261000008,C261000009,C261000010,C261000011,C300469200,
   C300469300,C300495800,C300787900)
   VALUES
   (:old.C1,:old.C2,:old.C3,:old.C4,:old.C5,:old.C6,
   :old.C7,:old.C8,:old.C102,:old.C109,:old.C115,:old.C179,
   :old.C100000106,:old.C100000113,:old.C100000120,
   :old.C100000121,:old.C100000122,:old.C200000006,
   :old.C200000007,:old.C200000012,:old.C230000009,
   :old.C240000001,:old.C240000003,:old.C240000004,
   :old.C240000005,:old.C240000006,:old.C240000007,
   :old.C240000008,:old.C240000009,:old.C240000010,
   :old.C240000011,:old.C240000035,:old.C240000036,
   :old.C240000037,:old.C240000038,:old.C240000040V,
   :old.C240000040C,:old.C240000040D,:old.C240000040USD,
   :old.C240000040EUR,:old.C240000040GBP,:old.C240000040JPY,
   :old.C240000041,:old.C240000042,:old.C260000000,
   :old.C260000001,:old.C260000002,:old.C260000003,
   :old.C260000004,:old.C260000005,:old.C260000006,
   :old.C260000008,:old.C261000009,:old.C260000010,
   :old.C260000026,:old.C261000002,:old.C261000008,
   :old.C261000009,:old.C261000010,:old.C261000011,
   :old.C300469200,:old.C300469300,:old.C300495800,
   :old.C300787900);
   end;
   /
   
   

3. Run the script.