SELECT
  resourceID,
  name
INTO
  :resourceID,
  :name 
FROM
  Resources 
WHERE statusCode <> :statusCode