hi ,

this is my trigger...saying compile error..could u help


CREATE OR REPLACE trigger Trigger2
AFTER UPDATE OF cancellationdatetime ON reservation
FOR EACH ROW
DECLARE

BEGIN
-- i am selecting reservation from this...it will return only one row..
SELECT reservationid FROM reservation WHERE
floor ((startdatetime - cancellationdatetime)*24) -
floor(startdatetime - cancellationdatetime)*24
<
48;
INSERT INTO charges VALUES (TO_DATE('12/09/2003-23-23-23','MM/DD/YYYY-HH24-MI-SS'),'FINE',50.00,reservationid);

END;
/

Take a few moments to read 'Must Read Before Posting' Thread ...

Cheers
Sathyaram