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