oracle8.1.6 update apm_package_versions set distribution_tarball = empty_blob(), distribution_uri = null, distribution_date = sysdate where version_id = :version_id returning distribution_tarball into :1 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;