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.