Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    2

    Unanswered: Trigger for three tables compilation error

    I have three tables

    mountain(mountain_name, hight)
    --
    expedition(expedition_id, hight_achieved)
    --
    member( expediton_id, mountain_name)
    ---------------

    The height_achieved field in the member table can never be higher than the mountain the expedition was on. The trigger should fire when a new member record is added and also any time data in the height_acheived column is updated
    -------------

    Please tell me where to binge I have no idea how to do it
    I tried so many time and all with error

    Trigger is completed with compilation error

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    what´s about

    CREATE OR REPLACE TRIGGER myschema.member AFTER INSERT FOR EACH ROW
    BEGIN

    .
    . Place your code here
    .

    END;

    and

    CREATE OR REPLACE TRIGGER myschema.member AFTER UPDATE OF hight_achieved FOR EACH ROW
    BEGIN

    .
    . Place your code here
    .

    END;

    Hope that helps
    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •