Stack Overflow
Stack Overflow

Questions tagged [oracle-soda]

8 questions
3
votes
1 answer

Passing in a JSON_OBJECT_T into SODA_DOCUMENT_T

I have a PL/SQL handler using the SODA package to manipulate a JSON database. I want to: Read the value for key id in the payload Write the payload JSON into a new document in the database. To do step 1, The handler takes :body to be parsed as a…
David Min
  • 1,246
  • 8
  • 27
3
votes
1 answer

Oracle Soda - VERSION field use case

I am studying Oracle SODA for using it as no-sql's document-store in my Java project. Each collection is represented as an SQL table in the Oracle database. This table is composed by some fields like BLOB that contains the JSON payload, and VERSION…
michele
  • 26,348
  • 30
  • 111
  • 168
2
votes
2 answers

Unable to establish a connection with Oracle Autonomous Data warehouse (ADW) or with Autonomous JSON Database from windows machine

I have been trying to establish a connection with my database on Oracle OCI, their database being ADW or AJD, but the connection does not establish even with the correct credentials passed. Please find my code below for reference. I have used and…
rohithrajan
  • 41
  • 5
0
votes
2 answers

Insert Document into Oracle SODA Collection Created with CREATE_MODE_MAP

We have a node.js app with Oracle DB as backend that uses SODA API. Per our internal DB policy there is a OWNER schema which owns tables while USER schema is used to access objects owned by OWNER schema to perform CRUD operations on them. Can the…
Kartik
  • 3
  • 2
0
votes
1 answer

Inserting new JSON document into Oracle Autonomous JSON Database

With Database Actions (SQL Developer Web), it's quite easy to click on the 'New JSON Document' button to add a new JSON document to the collection. The collection of course is actually a table in Oracle, and the table itself has a number of…
David Min
  • 1,246
  • 8
  • 27
0
votes
2 answers

Oracle SODA : creating tables manually

I want to use Oracle SODA, but the user that connects to the DB from the java application cannot modify tables, for security reasons. I did grant the "SODA_APP" to the schema, so the SODA java lib works (it calls the SODA pl/sql functions), but…
Filip
  • 906
  • 3
  • 11
  • 33
0
votes
1 answer

ATP and AJD stores JSON incorrectly

I am inserting data into the collections as a JSON in the following format soda insert emp {"name" : "Miller", "job" : "Programmer", "salary" : 90000} When I try to retrieve it using the soda get emp -f {"name":"Miller"} command The returned data…
rohithrajan
  • 41
  • 5
0
votes
1 answer

Oracle SODA - How to sort on created using REST?

I can't work out how to use the $orderby with SODA on an id field (such as created or lastModified. I'm using SODA for REST directly and not the other projects. Sort syntax is: { $orderby: { path: 'created', datatype: 'date', order:…
Joel Nation
  • 115
  • 7