All Questions
Tagged with oracle-rest-data-services sql
4 questions
0
votes
0
answers
40
views
JSON_OBJECT_T stringify CLOB is unable to stringy for huge data
I'm using the PLSQL procedure to return the data from the table and the ORDS will convert the CLOB to string using stringify function but the stringify is failing if i'm trying to conver huge data ...
- 99
0
votes
1
answer
71
views
ORDS PL/SQL block is unable to parse the input JSON and merge or delete the records
I'm trying to create one ORDS REST API in my 19c oracle ATP database, i.e. to accept the JSON input payload in my RESTG request (POST HTTP method) and try to insert, update, delete the header ...
- 99
0
votes
1
answer
43
views
unbale to get the data from ORDS plsql block if input is an json array of objects
I'm using below PLSQL block within my Oracle ORDS where my current input json body is like below
['123','456']
but i want to change the input json body to below format (unable to decide the logic)
[{
...
- 99
0
votes
1
answer
2k
views
REST API inserting into a table with 'GENERATED ALWAYS' column
I'm using Oracle's Autonomous Database service, with ORDS providing the REST functionality.
When making updates to a table (docs here), when I have an identity column id that is GENERATED ALWAYS, it ...
- 1,475