oracle8.1.6 select content_item.get_path(item_id) path, item_id from cr_items where item_id = ( select item_id from cr_revisions where revision_id = :revision_id)