PL SQL JSON response insert table


#1

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

{“Postcode”:“47100”,“OutletCode”:“128039251”,“MobileNumber”:“0123071303”,"_createdAt":“2014-11-10 06:12:49.837”,"_updatedAt":“2014-11-10 06:12:49.837”}


#2

DB version is oracle 10g


#3

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


#4

Hello @sersoy.

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.