This content has been marked as final. Show 5 replies
By fixed length file do you mean fixed-length records or a fixed-length fields with records separated by new line? By fixed, do you mean fixed number of bytes or fixed number of characters? Have you looked at the file in hex (in an editor with hex display or using the Unix 'od' utility)? What is the code of "ö" in the file?
CREATE TABLE "APP_XXX_XX_XXXX"(
"XXX_XXX_XXXXX" VARCHAR2(1 CHAR),
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "DIR"
( RECORDS DELIMITED BY NEWLINE
KEY_NO POSITION(1:9) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(10:10) CHAR,
XXX_XXX_XXXXX POSITION(11:19) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(11:14) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(15:16) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(17:19) INTEGER EXTERNAL)
REJECT LIMIT UNLIMITED
The data forms part of a major driver table, which I may not be able to provide as per the NDA with my company.
The Script I have shared is standard template for creating external table as part of our applications.
We majorly cater for EU regions with this project.(European Characterset needed to be supported)
Edited by: RGRAM on Feb 11, 2011 12:44 PM
Please post the exact content of the record from the input file that contains the word "Göteborg" as seen in a hex editor. If there is any sensitive information there, you can first mask it out by replacing certain ASCII letters with 'X' (but do not change the non-ASCII letters, such as "ö").
000000000NX X X XXX SCOTLAND 0000000000 0001200448705325325 19940000000000523180000000000020000488G00313559901376 AB Göteborg_ XXXXXX 717640967881X X X XXX 785353952559XX XXXXX Göteborg_ XXXXXX 717320101204
Edited by: RGRAM on Feb 11, 2011 12:47 PM
Edited by: RGRAM on Feb 11, 2011 12:51 PM
... as seen in a hex editor ...