INSERT from rowtype

DECLARE

  r_person persons%ROWTYPE;

BEGIN

  -- assign values to person record

  r_person.person_id  := 1;

  r_person.first_name := 'John';

  r_person.last_name  := 'Doe';

  -- insert a new person

  INSERT INTO persons VALUES r_person;

END;