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