Hello,
I have a code which contains
l_catg_req := UTL_HTTP.begin_request('https://api.testsolut/settings/v1/test','GET');
UTL_HTTP.set_header (l_catg_req, 'session_id', l_session_id);
l_catg_resp := UTL_HTTP.get_response(l_catg_req);
UTL_HTTP.read_text(l_catg_resp, l_response_text);
-- DBMS_OUTPUT.put_line(l_response_text);
l_list := json_list(l_response_text);
Which execution I am getting:
ORA-20100: JSON Scanner exception @ line: 1 column: 32415 - string ending not found
ORA-06512: at "APPS.JSON_PARSER", line 92
ORA-06512: at "APPS.JSON_PARSER", line 283
ORA-06512: at "APPS.JSON_PARSER", line 390
ORA-06512: at "APPS.JSON_PARSER", line 668
ORA-06512: at "APPS.JSON_LIST", line 11
ORA-06512: at line 82
I read in one article json could not parsed as there must be some special characters in the list.
How to escape the special character