SELECT
  DISTINCT CASEPARTICIPANTROLE.PARTICIPANTROLEID,
  CONCERNROLE.CONCERNROLENAME,
  PERSON.DATEOFBIRTH,
  PERSON.GENDER
INTO
  :concernRoleID,
  :name,
  :dateOfDeath,
  :gender 
FROM
  CASEPARTICIPANTROLE,
  CONCERNROLE,
  PERSON 
WHERE CASEPARTICIPANTROLE.PARTICIPANTROLEID = CONCERNROLE.CONCERNROLEID 
  AND CONCERNROLE.CONCERNROLEID = PERSON.CONCERNROLEID 
  AND CASEPARTICIPANTROLE.CASEID = :caseID