oracle8.1.6 begin :1 := content_revision.new(title => :title, item_id => :item_id, v_content => null); end; update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 select r.mime_type, i.storage_type, i.storage_area_key, r.revision_id from cr_revisions r, cr_items i where i.item_id = r.item_id and r.revision_id = content_item.get_live_revision(:item_id) select :path || filename from cr_revisions where revision_id = :revision_id select content from cr_revisions where revision_id = $revision_id