As Oracle says : ORA-01401: inserted value too large for column

You try to insert into TIPO_OGG "VARCHAR2(10)" data from column
USE1 "VARCHAR2(32)"