Unable to Insert (POST) Data Via Oracle Rest Data Services using AutoREST
(Doc ID 2445887.1)
Last updated on OCTOBER 17, 2023
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle REST Data Services - Version 3.0 and later
Information in this document applies to any platform.
Symptoms
NOTE: In the example below is for demonstration purposes only. The user information and data used represents fictitious data. Any similarity to actual data and / or persons, living or dead, is purely coincidental and not intended in any manner.
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.
https://<ipaddress>/ords/<SCHEMA_ALIAS>/examples/emp - 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:!Secure
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.
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 |