#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