oracle8.1.6 begin content_revision.to_temporary_clob(:revision_id); end; select content from cr_content_text where revision_id = :revision_id select [ad_decode $storage_type file "'[cr_fs_path]' || filename" content] from cr_revisions where revision_id = $revision_id select content from cr_content_text where revision_id = :revision_id