oracle9.2
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
begin
:1 := acs_message.new (
message_id => :comment_id,
reply_to => NULL,
sent_date => current_timestamp,
sender => NULL,
rfc822_id => NULL,
title => :title,
description => NULL,
mime_type => :mime_type,
text => NULL,
data => empty_blob(),
parent_id => 0,
context_id => :object_id,
creation_user => :user_id,
creation_ip => :peeraddr,
object_type => 'acs_message',
is_live => :is_live
);
end;