Pljson Versions Save

alias without {} for json string

• pljson_dyn: ORDS feature to not escape string which is json; spelling fixes
• fix #284, new datatypes and same handling in executeList and executeObject
• fix #281
• null => null (vs "") for clob, for char when empty_string_as_null = true
• parameter columndateformats for executeList(), refactorings
• fix pretty_print_any() to pass erase_clob in object/list calls
• reviewed clob usage

• fix pretty_print_any() to pass erase_clob in object/list calls

fix for get_ functions when no field value to return

fix for get_ functions when no field value to return

• improved path syntax
• fixed helper package
• updated tests
• parser speed optimization ported from v2

review and homogenization of clob code with v2 (#239 4 byte Unicode chars) #245 (sql_to_json() - string with leading zero returns exception) #237 second issue fix (NLS_NUMERIC_CHARACTERS other than AMERICAN) #237 (number format of pljson_util_pkg.sql_to_json) update the base64 data #236

#245 (sql_to_json() - string with leading zero returns exception)
#239 4 byte Unicode chars #237 second issue fix (NLS_NUMERIC_CHARACTERS other than AMERICAN) backport 1/2 from v3.5.0

• fix issue #223 (original correct return statement for border case)

• fix issue #222 (pljson_util_pkg.sql_to_json() where sql query selects & or <)

• further code improvements in pljson_util_pkg.sql_to_json()

• fix for overlapping printing of data

• fix the examples to work out of the box

• fix example ex13.sql to avoid exceeding SQL*Plus line length limit

• remove example.pdf(s) that advertise commercial software

• add tests for pljson_table

• add an example for pljson_table that selects from a table's column data

the changes that are relevant to version 2 will be backported

fix for issue #213 (sql_to_json() with special characters)