oracle 8.1.6 update cr_revisions set content = empty_blob() where revision_id = :revision_id returning content into :1 update $lob_table set $lob_attribute = empty_clob() where $lob_id_column = :revision_id returning $lob_attribute into :1