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!

Padded Spaces

324649Oct 8 2002

I have a set of flat files that I am loading into oracle through OWB, I need to be able to convert the char character to a varchar and to delete the 'white spaces in every field'.

I have tried using a trim function but receive the following error:-

SQL*Loader-951: Error calling once/load initialization
ORA-26097: unsupported conversion for column (from type 1 to type 49)

How can this be done with owb ??

Regards

Paul Heath

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2002

Added on Oct 8 2002

#data-warehousing, #warehouse-builder

1 comment

204 views