I'm trying to query a table in an Oracle table with a field that is JSON. I am using the JSON_VALUE function in the sql. Some of the JSON fields contain spaces so I put double quotes around values and this works when running the query outside of JSL but throws an error running the query as shown below in jsl. Thanks in advance for any hep you can provide.
JSL:
dbc = create database connection("Driver={Oracle in InstantClient11_1};UID=xxxx;DBQ=yyyy;PWD=zzzz;");
user_sql ="select json_value(feature, '$."ball dimension"') as ball_dimension from blah";
user_dt = execute sql(dbc, user_sql);
