Can you run this from sqlplus/psql, updating the table directly? Maybe a trigger procedure is not doing the right thing?