SET

Here is a simple way to upgrade all sequence generator datatypes so that version 8.1 Informatica mappings will work with version 8.6. UPDATE OPB_WIDGET_FIELD SET wgt_prec = 19, wgt_datatype = -5 WHERE  field_name IN ( ‘CURRVAL’,’NEXTVAL’) AND wgt_datatype = 4;