You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBMS_CLOUD.CREATE_EXTERNAL_TABLE handling accent marks in text

Accepted answer
edited Aug 18, 2020 12:52PM in Autonomous Database 4 comments


KUP-04021: field formatting error for field ADDRESSLINE1 when loading external table where text string contains special characters



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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!