ORDS Batch Load Feature Fails When Table Has Invisible Columns
(Doc ID 2726572.1)
Last updated on FEBRUARY 15, 2023
Applies to:
Oracle REST Data Services - Version 19.1 and laterInformation in this document applies to any platform.
Symptoms
NOTE: The example(s) provided are for demonstration purposes only and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.
AutoREST has been configured for a specific table and schema in the database.
When running a batchload request against the table, the request runs successfully:
curl -i -X POST --data-binary @/tmp/data2.csv -H "Content-Type: text/csv" http://localhost:8080/ords/hr/employees/batchload?batchRows=100
However, if a database column is made invisible:
alter table <TABLE_NAME> modify <COLUMN_NAME> invisible;
The same request with the same data fails.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |