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 later
Information in this document applies to any platform.
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.
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