oracle8.1.6 select content_item.get_live_revision( content_item.get_id( :path, file_storage.get_root_folder([ad_conn package_id]) ) ) as version_id from dual select content from cr_revisions where revision_id = $version_id select '[cr_fs_path]' || filename as content from cr_revisions where revision_id = $version_id select mime_type,(case when filename is null then 1 else 0 end) as indb_p from cr_revisions r where revision_id = :version_id