postgresql7.1 select content_item__get_live_revision( content_item__get_id( :path, file_storage__get_root_folder([ad_conn package_id]), 'f' ) ) as version_id from dual select r.lob as content, i.storage_type from cr_revisions r, cr_items i where r.item_id = i.item_id and r.revision_id = :version_id