value starting with zeros '0' (eg. 012345, 0005677882) is not getting updated in oracle.

We have a concurrent program to create/update/delete the item cross references in Oracle apps (11i). We are using EXECUTE IMMEDIATE to execute the update statement.

When we are updating the table through database we are able to update the values with zero but not through concurrent program.

 v_statement_upd :=         'UPDATE mtl_cross_references mcr';

   v_statement_upd := v_statement_upd||'  set mcr.cross_reference = '||to_char(v_rec.cross_reference_value1)||',mcr.last_updated_by = '||v_rec.last_updated_by||',mcr.last_update_date = SYSDATE';

   v_statement_upd := v_statement_upd||' where 1 = 1';