oracle8.1.6 select template_id, content_item.get_path(template_id) path from cr_templates where template_id in ($in_list)