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 for csv with newline inside field

in Database 1 comment

Summary: I have a standard comma-separated csv file stored in a bucket, with header composed by the first 2 rows. Some text contains \n (newline) that is not the end of the record, but it is inside the field. I want to create an external table that access the csv file, actually I receive the followinf error

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01006: error signalled during parse of access parameters
KUP-02001: unrecognized punctuation symbol ""

Content (please ensure you mask any confidential information):

SHIP_UNIT_REMARK
SHIP_UNIT_GID,REMARK_SEQUENCE,REMARK_QUAL_GID,REMARK_TEXT,DOMAIN_NAME,INSERT_USER,INSERT_DATE,UPDATE_USER,UPDATE_DATE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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