All geek questions in one place

JSON support in Oracle 11g

Does Oracle 11g support JSON? I mean things like manipulating JSON objects in PL / SQL queries. I know that Oralcle 12c has support for these things, but 11g doesn't seem to.

My main problem is whether it is possible to handle JSON objects returned from RESTfull API calls (using the package UTL_HTTP) in PL / SQL code.

This is what I call the RESTfull API:

req := UTL_HTTP.BEGIN_REQUEST('https://xxxx/api/job/all', 'GET', 'HTTP/1.1');

  UTL_HTTP.set_header(req, 'Content-Type', 'application/json');
  UTL_HTTP.set_header(req, 'apikey','xxxxx');
  resp := UTL_HTTP.GET_RESPONSE(req);

Then you need to somehow save the received JSON data in the tables. Enrichment of my Oracle: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64-bit production.

Any thoughts?

Thank.

+4
source share
2 answers

No, JSON support was introduced in the Oracle 12c release 2 database (12.1.0.2)

+3

APEX 5.0, 15 . API JSON

11.2 json, 4/5 . APEX_JSON

APEX. , API.

+6

Source: https://habr.com/ru/post/1589395/

More articles:


All Articles