# PL SQL JSON response insert table

**URL:** <https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383>\
**Category:** Uncategorized\
**Created:** [September 11, 2018, 7:26pm UTC](https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383 "2018-09-11T19:26:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sersoy](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@sersoy](https://discuss.jsonapi.org/u/sersoy)\
**Post date:** [September 11, 2018, 7:26pm UTC](https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383/1 "2018-09-11T19:26:19Z")

</div>

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”}

---

<div class="post-metadata">

**Author:** ![sersoy](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@sersoy](https://discuss.jsonapi.org/u/sersoy)\
**Post date:** [September 11, 2018, 7:26pm UTC](https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383/2 "2018-09-11T19:26:54Z")

</div>

DB version is oracle 10g

---

<div class="post-metadata">

**Author:** ![sersoy](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@sersoy](https://discuss.jsonapi.org/u/sersoy)\
**Post date:** [September 12, 2018, 8:25am UTC](https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383/3 "2018-09-12T08:25:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![rewritten](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.jsonapi.org/rewritten/32/568_2.png) [@rewritten](https://discuss.jsonapi.org/u/rewritten)\
**Post date:** [September 27, 2018, 8:44am UTC](https://discuss.jsonapi.org/t/pl-sql-json-response-insert-table/1383/4 "2018-09-27T08:44:42Z")

</div>

Hello @sersoy.

This forum is about the JSONAPI specification (as defined in [jsonapi.org](http://jsonapi.org)). Your data is not in that format, and implementation details are anyways off-topic. You’d better ask in [stackoverflow.org](http://stackoverflow.org) where you will find a lot of help for implementations.