select category_id
from ttracker_categories
where upper(name) = upper(:name) and
package_id = :package_id and
category_id != :category_id
update ttracker_categories
set name = :name,
description = :description,
default_assignee = :default_assignee
where category_id = :category_id