oracle8.1.6 select content, mime_type from cr_revisions where revision_id = content_item.get_live_revision(:content_item_id) select header_subject as title, to_char(send_date, 'Month DD, YYYY HH:MI:SS') as send_date, content_item_id from spam_messages_all where spam_id = :spam_id