title: Create Instead of Insert Trigger
body: <p>I am a beginner at Oracle. I am trying to create an INSTEAD OF trigger to enforce a rule that no tutor should work more than 60 hours in a month </p>
  
  <p>This is what I have so far</p>
  
  <pre><code>    CREATE TRIGGER limit_hour
      INSTEAD OF INSERT ON SESSIONHOURS 
      DECLARE
      totalHours NUMBER := 60;
      monthOnly DATE;
      totalSession NUMBER;
      FOR EACH ROW
      BEGIN
        INSERT INTO SESSIONHOURS(SESSIONDATEKEY, TUTORKEY, TOTALSESSION)
        SELECT EXTRACT (MONTH FROM DATE S.SESSIONDATEKEY), S.TOTALSESSION
        INTO monthOnly, totalSession
      FROM SESSIONHOURS S
      END;
  </code></pre>
  
  <p>The error "inappropriate INTO" keeps popping up. Also I need to assign the total sum of each session(30 min each) for the extracted month and then compare it with  the "totalHour". How do I assign a time value to a date value? Any suggestions would be appreciated  </p>