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