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