oracle8.1.6
begin
:1 := content_item.new(name => :name,
creation_ip => :creation_ip,
storage_type => 'file'
);
end;
begin
:1 := content_revision.new(title => :title,
description => 'gzipped tarfile',
text => 'not_important',
mime_type => 'text/plain',
item_id => :item_id,
creation_user => :user_id,
creation_ip => :creation_ip
);
update cr_items
set live_revision = :1
where item_id = :item_id;
end;
update cr_revisions
set filename = '[set content_file [cr_create_content_file $item_id $revision_id $tmpfile]]'
where revision_id = :revision_id
update apm_package_versions
set content_length = [cr_file_size $content_file]
where version_id = :version_id
select '[cr_fs_path]' || r.filename as content, i.storage_type
from cr_revisions r, cr_items i
where r.item_id = i.item_id
and r.revision_id = (select content_item.get_latest_revision(item_id)
from apm_package_versions
where version_id = :version_id)
begin
:1 := apm_package_version.add_file(
file_id => :file_id,
version_id => :version_id,
path => :path,
file_type => :file_type,
db_type => :db_type
);
end;
begin
apm_package_version.remove_file(
path => :path,
version_id => :version_id
);
end;