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
10
Views
4
Comments
edited Aug 18, 2020 12:52PM in Autonomous Database 4 comments

Summary

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

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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