SELECT
  Outcome.outcomeID,
  Outcome.name
INTO
  :outcomeID,
  :name 
FROM
  SubGoal,
  Outcome,
  SubGoalOutcomeLink 
WHERE SubGoal.subGoalID = SubGoalOutcomeLink.subGoalID 
  AND SubGoalOutcomeLink.outcomeID = Outcome.outcomeID 
  AND SubGoal.subGoalID = :subGoalID