SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  Resources 
WHERE UPPER(name) = :name 
  AND Resources.statusCode <> :statusCode