I keep getting an error when I try to execute an example of the following update stored procedure, so please fix error:
CREATE OR REPLACE TRIGGER Flight_Departure BEFORE DELETE OR INSERT OR UPDATE ON Flight
FOR EACH ROW
DECLARE
Old_departure_hour VARCHAR2(20);
new_departure_hour VARCHAR2(20);
Flight_number NUMBER;
FLIGHT_DEPARTURE_HOUR NUMBER;
BEGIN
SELECT Departure_hour INTO Old_departure_hour
FROM Flight
WHERE Flight_no=Flight_number
FOR UPDATE OF Departure_hour;
new_departure_hour:=Flight_Departure_hour;
UPDATE Flight SET Departure_hour=new_departure_hour
WHERE Flight_no=Flight_number;
EXCEPTION
WHEN NO_DATA_FOUND THEN
INSERT INTO Flight (Flight_no, Departure_hour) VALUES(Flight_number, Flight_Departure_hour);
END Flight_Departure;
/
While I used this sentence to execute update stored procedure:
EXEC Flight_Departure('AI1992', '1:00 AM');
This is the rest of code: Creating Flight Table: CREATE TABLE Flight Flight_no VARCHAR2(10) NOT NULL UNIQUE, Flight_Date date, Departure_airport VARCHAR2(20), Arrival_airport VARCHAR2(20), Departure_hour VARCHAR2(10), Arrival_hour VARCHAR2(10), Flight_type VARCHAR2(20) ); --Inserting Values in Flight Table: INSERT INTO Flight VALUES ('A11992', '13-Apr-2022', 'Jeddah', 'Delhi', '9:30 AM', '4:30 PM', "International Flight');