oracle8.1.6 select count(*) from cr_revisions where revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions where version_id = :version_id) select '[cr_fs_path]' || filename as content, '[set storage_type file]' as storage_type from cr_revisions where revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions where version_id = :version_id)