pl/sql library for JSON

Français

Here is the first release of a PL/SQL package for JSON (Javascript Simple Object Notation). This program is published under the GNU LGPL License.

The package’s features are :
– create and manipulate JSON objects
– add attributes and array to a JSON object
– convert from JSON to string
– convert from String to JSON structure
– debugging function
– customizable output (web or custom)

a little test procedure gives an idea of capabilities of this package.

The 1.1 version has released. Here the changelog between 1.0 and 1.1

– Add some stuff to prevent from javascript Hijacking, prototype framework compatible :

/*-secure-\n{...json object...}\n*/
– Add procedure to send appropriate mime type for Web output "application/json"
– printing enhancement.
– suppress global variable g_output_type.
– bug corrections in String2Json func.
– Add procedure to stream out the json object
– Suppress indentation for better perf on long json objects.
– Refactor terms to match on the english terms
– bug correction in getAttrValue, add param pOutPutStringDelimiter and pOutPutSeparator

that allows to format the output of the function.
– Add function getAttrArray that return an array of values in an plsql array of varchar2
– Add Array2String utility.
– Add License informations

The 1.0 version has released.

– Added a basic validation function to validate struture of JSON objects.