Archive

Archive for July, 2015

JSON Update for the Impatient

July 30, 2015 8 comments

Waiting for a future(?) Oracle implementation in the database, this post presents a JSON Update API for SQL and PL/SQL.

The API comprises two parts :

  • A JSON model, using the org.json reference implementation written in Java.
    The package is used as is, except for the additional org.json.JSONArray.insert() method I’ve added to handle insert operations in arrays.
  • A JSON Path Expression parser (strict syntax), following the specifications edicted here : http://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6255

All implemented updating methods are made available in SQL and PL/SQL via a dedicated package that interfaces the Java methods.

The PL/SQL package, JAR and Java source code are available here : json_util.zip

Read more…

Advertisements
Categories: JSON Tags: , , ,