oracle8.1.6 select 0 as tree_level, '' as name , 'Home' as title from dual UNION select t.tree_level, i.name, content_item.get_title(t.context_id) as title from ( select context_id, level as tree_level from acs_objects where context_id <> content_item.get_root_folder connect by prior context_id = object_id start with object_id = :item_id ) t, cr_items i where i.item_id = t.context_id order by tree_level begin content_revision.to_temporary_clob(:revision_id); end; select content from cr_content_text where revision_id = :revision_id select item_id, content_type from cr_items where item_id = content_item.get_id(:url, :content_root) select item_id, content_type from cr_items where item_id = content_item.get_id(:url, :template_root) select (select live_revision from cr_items where item_id = content_item.get_template(:item_id, :context)) as template_id, content_template.get_path( content_item.get_template(:item_id, :context),:template_root) as template_url from dual