select pretty_name,
description
from dotlrn_classes_full
where class_key = :class_key
update dotlrn_community_types
set pretty_name = :pretty_name,
description = :description
where community_type = :class_key
select package_id
from dotlrn_classes_full
where class_key = :class_key