title: select into inside a trigger statement
body: <p>i have this trigger:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER TR_SIGHTING_DESC
  BEFORE INSERT ON sightings
  FOR EACH ROW
  BEGIN
  SELECT bird_name
  INTO bn
  from birds
  where bird_id = :new.bird_id;    
      :new.description := 'A bird of the species ' 
                          || bn 
                          || ' was spotted in the ' 
                          || :new.latitude || ','|| :new.longitude 
                          || ' part of the observation area';
  END;
  /
  </code></pre>
  
  <p>it keeps saying its invalid. Im trying to retrieve bird_name form its corresponding ID, when say for example this is inserted into the sightings table:</p>
  
  <pre><code>INSERT INTO sightings (spotter_id, bird_id, latitude,
  longitude, sighting_date)
  VALUES (2457, 901, -28.0, 152, '09-MAR-2016');
  </code></pre>