oracle8.1.6 select g.comment_id, g.related_object_id as object_id, r.title, r.content, r.mime_type as comment_mime_type, acs_object.name(g.related_object_id) as object_name from general_comments g, cr_revisions r where g.comment_id = :comment_id and r.revision_id = nvl(content_item.get_latest_revision(:comment_id),:revision_id)