My Oracle Support Banner

ORDS Batch Load Feature Fails When Table Has Invisible Columns (Doc ID 2726572.1)

Last updated on JUNE 21, 2021

Applies to:

Oracle REST Data Services - Version 19.1 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.