oracle8.1.6 select mime_type from cr_revisions where revision_id = content_item.get_live_revision(:file_id) select content from cr_revisions where revision_id = content_item.get_live_revision($file_id)