oracle8.1.6
begin
:1 := content_revision.new (
item_id => :item_id,
title => :title,
description => :description,
mime_type => :mime_type,
creation_user => :user_id,
creation_ip => :ip_address
);
end;
update cr_revisions
set content = empty_blob()
where revision_id = $revision_id
returning content into :1