oracle8.1.6 begin content_revision.to_temporary_clob(:revision_id); end; select content from cr_content_text where revision_id = :revision_id select content_item.get_live_revision(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