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!

Number format from a file

390194Oct 14 2003 — edited Jun 26 2006

Hi,

I have a problem whereby I am loading data from a flat file using OWB, the data I want to import is a number, but in the file it is represented in the format 1,234,567.

I would like to be able to load this straight into a column of NUMBER datatype, however I am getting an invalid number error.

I have tried to use the TO_NUMBER function in the OWB mapping (in between the file and the table) but I get a SQL loader error - 417 SQL String XXX not allowed in direct path.

I have also tried to use a format mask, but OWB does not like this at all.

The database is 8.1.7, so I can't use external tables, and I am aware I could resolve the issue using 2 mappings, but this will double the workload and maintenance (there are a large number of file with this number format). Does anyone have any ideas how to resolve this in one mapping from the file to the table?

Thanks,

Jon

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2006

Added on Oct 14 2003

#data-warehousing, #warehouse-builder

6 comments

1,142 views