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
Tagged:
0