DBMS_CLOUD.CREATE_EXTERNAL_TABLE handling accent marks in text
Summary
KUP-04021: field formatting error for field ADDRESSLINE1 when loading external table where text string contains special charactersContent
Hi,
I'm hoping you can help me. I have an address file where some of the addresses have accents above letters which is causing validation errors when creating the external table using DBMS_CLOUD.CREATE_EXTERNAL_TABLE. An exsert of the address file showing the accent mark in bold (full file attached).
11784 1663 Park Glen Court Lakewood 9 90712 E6100000010C5946572343DF4040972E30AB78865DC0 {B9DCC8DE-09E8-495B-84CB-764ECB62675C} 2013-10-27 00:00:00 11785 1234, rue Ste-Honoré Saint-Denis 179 93400 E6100000010CE9EC9DA1C96E48405277197595AA0240 {0334F558-C1E9-4E19-8AB0-17E90039B1D5} 2013-12-21 10:09:29.423000000 11786 2650 Hamlet Portland 58 97205 E6100000010CC132F70F70C34640F966B77092B25EC0 {997F9262-8996-4E98-950F-562031F9705D} 2013-08-07 00:00:00
Tagged:
0