Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01862

24314Jun 14 2006 — edited Jun 16 2006

Hi,

I have a mapping that worked OK but broke after softwares upgrade from 9iDB/OWB9i to DB10gR2/OWB10.1.0.4. The message I received is

ORA-01862: the numeric value does not match the length of the format item

It's a simple truncate/insert operation from view source to table. It works fine though when executing the action through plsql. What can be wrong?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2006

Added on Jun 14 2006

#data-warehousing, #warehouse-builder

6 comments

2,223 views