SELECT
  Alert.alertID,
  Alert.category,
  Alert.dateCreated,
  Alert.userName,
  Alert.processID,
  Alert.processActivityID,
  Alert.processVersion,
  Alert.wdoSnapshot,
  Alert.overflowInd,
  Alert.notificationType,
  Alert.notificationID
INTO
  :alertID,
  :category,
  :dateCreated,
  :userName,
  :processID,
  :processActivityID,
  :processVersion,
  :wdoSnapshot,
  :overflowInd,
  :notificationType,
  :notificationID 
FROM
  Alert 
WHERE Alert.userName = :userName