oracle8.1.6 select dotlrn_communities.pretty_name, dotlrn_communities.description, dotlrn_community.url(:community_id) as url from dotlrn_communities where dotlrn_communities.community_id = :community_id