Hi,
I am getting JSON format response from web server
I want to insert a table this response
exampe in table postcode field I want to insert 47100 that comes from JSON response data
can you help me
I am getting this error now but online formatter it says valid JSON
ORA-20100: JSON Scanner exception @ line: 1 column: 2 - Unexpected char: {
ORA-06512: at “APPS.JSON_PARSER”, line 87
ORA-06512: at “APPS.JSON_PARSER”, line 447
ORA-06512: at “APPS.JSON_PARSER”, line 669
ORA-06512: at “APPS.JSON_LIST”, line 11
This forum is about the JSONAPI specification (as defined in jsonapi.org). Your data is not in that format, and implementation details are anyways off-topic. You’d better ask in stackoverflow.org where you will find a lot of help for implementations.