triggers

fahad · #1 (**permalink**) 04-02-04, 02:16

I have 2 tables BOOKING (booking_id, car_id) and CAR (car_id, car_availability). the field car_availability takes the value YES/NO. I want to create a trigger in oracle so that whenever I make an entry in the BOOKING table for car_id, that same car_id 's availability in the CAR table should be set to NO.

zeus77 · #2 (**permalink**) 04-02-04, 02:29

try this:

create or replace trigger ins_booking after insert on booking
begin
update car
set car_availability='NO'
where car_id in (select car_id from :NEW);
END;

Littlefoot · #3 (**permalink**) 04-02-04, 05:17

I'm afraid your trigger won't compile, Zeus ...

But this one will

PHP Code:


			
CREATE OR REPLACE TRIGGER trg_a_i_booking

   AFTER INSERT

   ON booking

   FOR EACH ROW

BEGIN

   UPDATE car

      SET car_availability = 'NO'

    WHERE car_id = :NEW.car_id;

END;

fahad · #4 (**permalink**) 04-05-04, 10:26

trigger has been created successfully but it is not doing what i want it to do. when inserting into the booking table, it is giving an error saying :

ORA-02291: integrity constraint () violated -parent key found

how should i proceed????
pls help

Internet Services

Web Development

Digital Marketing

Consumer Tech