oracle8.1.6
begin
:1 := content_item.new (
name => :filename,
parent_id => :folder_id,
context_id => :folder_id,
creation_user => :user_id,
creation_ip => :creation_ip,
item_subtype => 'file_storage_item' -- Needed by site-wide search
);
end;
begin
:1 := content_revision.new (
title => :title,
description => :description,
mime_type => :mime_type,
item_id => :item_id,
creation_user => :user_id,
creation_ip => :creation_ip
);
end;
update cr_revisions
set content = empty_blob()
where revision_id = :revision_id
returning content into :1
begin
content_item.set_live_revision(:revision_id);
end;