oracle8.1.6
begin
:1 := news.revision_new(
item_id => :item_id,
publish_date => :publish_date_ansi,
title => :publish_title,
description => :revision_log,
mime_type => :mime_type,
package_id => [ad_conn package_id],
archive_date => :archive_date_ansi,
approval_user => :approval_user,
approval_date => :approval_date,
approval_ip => :approval_ip,
creation_ip => :creation_ip,
creation_user => :creation_user,
make_active_revision_p => :active_revision_p);
end;
update cr_revisions
set content = empty_blob()
where revision_id = :revision_id
returning content into :1