Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Unable to copy JSON data from OCI Object storage to DB table

in Autonomous Database 3 comments

Summary:

I have a JSON payload in OCI Object Storage and is available through public URL.I am trying to copy this data to an existing table TEST_TABLE_MAIN
Question1) There is an additional column in the table which is not available in the JSON. Will DBMS_CLOUD_COPY_DATA work in this scenario if the additional column is at the last column position in the table?
Question2) After dropping the additional column & having JSON fields match exactly as the Table columns, am getting JSON syntax error.
Probably something is not proper in the columnpath which am not able to figure out.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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