oracle8.1.6
begin
:1 := acs_message.edit (
message_id => :comment_id,
title => :title,
mime_type => :comment_mime_type,
data => empty_blob(),
creation_user => :user_id,
creation_ip => :creation_ip,
is_live => :is_live
);
end;
select content_item.get_latest_revision(:comment_id) as revision_id
from dual
update cr_revisions
set content = empty_blob()
where revision_id = :revision_id
returning content into :1