#liste_articles {display:block}

pl/sql library for JSON

Monday 3 December 2007


pl/sql library for JSON


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

PL/SQL package for JSON
1.1 stable version

The 1.0 version has released.

PL/SQL package for JSON
1.0 stable version

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

Documents :

par Pierre-Gilles Levallois