i encountered a problem while using sql_to_json.
When the passed select statement had just 1 row as result, the function would return the json_list as follows :
but if there were more then one row as the result the json_list would be :
the fix is to change the line 318 in the json_util_pkg.sql from
Hope this helps someone.
or for cleaner code :
Changes are in v1.03