oracle8.1.6 update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 update cr_revisions set content_length = dbms_lob.getlength(content) where revision_id = :revision_id update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 begin :1 := acs_rel.new ( rel_type => 'email_image_rel', object_id_one => :user_id, object_id_two => :item_id); end;