Oracle Trigger create with compilation errors

Question

I wrote the below trigger to prevent users from allocating a Class to a Session if the Class Date does not match the day of the week the Session is on.

CREATE OR REPLACE TRIGGER trig_alternative_classDate
AFTER INSERT OR UPDATE ON ALTERNATIVE
FOR EACH ROW
DECLARE
    classdate CHAR;
    sessionday VARCHAR;
BEGIN
    SELECT to_char(to_date(class.class_date), 'Day') INTO classdate, sessions.day INTO sessionday
    FROM SESSIONS, CLASS, DUAL, LOCATION, ALTERNATIVE
    WHERE class.class_id = alternative.class_id
    AND alternative.location_id = location.location_id
    AND sessions.location_id = location.location_id;
    IF sessions.day != to_char(to_date(class.class_date), 'Day')
    THEN raise_application_error(-20999,'Invalid Class Date - Class Date does not match Session Day');
    END IF;
END;
/

However I get an error message when I run the trigger

Warning: Trigger created with compilation errors.

SQL> show error trigger trig_alternative_classDate
Errors for TRIGGER TRIG_ALTERNATIVE_CLASSDATE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/2  PL/SQL: SQL Statement ignored
5/80 PL/SQL: ORA-00923: FROM keyword not found where expected

Could someone please help?

Art · Accepted Answer · 2013-02-26 15:37:00Z

2

Remove second INTO - only one INTO is needed:

INTO classdate, sessions.day INTO sessionday

answered Feb 26, 2013 at 15:37

Art

5,8222 gold badges24 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Art Over a year ago

@Ben Townsend - Did you try? Works?

Collectives™ on Stack Overflow

Oracle Trigger create with compilation errors

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related