Search code examples
sqljsonoracleoracle11g

Support for JSON in Oracle 11g

Does Oracle 11g support JSON? I mean stuff like manipulating JSON objects in PL/SQL Queries. I know Oralcle 12c has the support for these things but it seems 11g does not.

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

This is how I call RESTfull APIs:

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 need to somehow save retruned JSON data in tables. My Oracle envirment is: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

Any thoughts?

Thank you.

Solution

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

    Regards