Unable to Insert (POST) Data Via Oracle Rest Data Services using AutoREST
(Doc ID 2445887.1)
Last updated on AUGUST 14, 2019
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle REST Data Services - Version 3.0 and later
Information in this document applies to any platform.
On : Oracle Database Cloud Service Environment
SQL Developer / ORDS is being used in order to create AutoREST services against a database table.
- When running insert / POST actions against objects that are stored in the System table space, the requests run successfully.
- When running insert / POST actions against the same objects stored in another table space, the same request fails.
The failure is different depending on whether the request is made in HTTP or HTTPS:
Error for HTTP
HTTP ERROR 403
Problem accessing https://<ipaddress>/ords/<SCHEMA_ALIAS>/examples/emp. Reason:
Error for HTTPS
Error Message (screen shoot available in attachment):
404 Not Found
- GET requests works regardless of whether or not the database object is in the system or a non-system table space.
It is possible to manually create the module / template / handlers and this works. However, they want to be able to use autoREST, since this will save development time.
Due to this issue, users are not able to move forward with POST operation using AutoREST.
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