oracle8.1.6
select content_item.get_title(:item_id) from dual
select content_item.is_publishable(:item_id) from dual
, content.blob_to_string(content) as text
select content_item__get_id(:url $root_sql) from dual
select 't' from cr_revisions r, cr_items i
where r.revision_id = :revision_id
and i.item_id = r.item_id
and ((r.content is not null and i.storage_type in ('lob','text')) or
(r.filename is not null and i.storage_type = 'file'))
select content_item.get_template(:item_id, :context) as template_id
from dual
select content_item.get_path(:item_id, $root_folder_id) from dual
select content_item.get_best_revision(:item_id) from dual
begin
content_item.delete(:item_id);
end;
begin
content_item.copy(
item_id => :item_id,
target_folder_id => :target_folder_id,
creation_user => :creation_user,
creation_ip => :creation_ip
);
end;
begin
content_item.set_live_revision(
revision_id => :revision_id,
publish_status => 'live'
);
end;
begin
content_item.unset_live_revision(
item_id => :item_id
);
end;