在Oracle 11g中支持JSON

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.

Oracle 11g是否支持JSON?我的意思是像在PL / SQL查询中操纵JSON对象。我知道Oralcle 12c对这些东西有支持,但似乎11g没有。

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.

我主要担心的是,是否可以在PL / SQL代码中处理从RESTfull API调用(使用UTL_HTTP包)返回的JSON对象。

This is how I call RESTfull APIs:

这就是我调用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 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.

然后需要以某种方式保存表中的重新生成的JSON数据。我的Oracle环境是:Oracle Database 11g企业版11.2.0.3.0版 - 64位生产版。

Any thoughts?

Thank you.

2 个解决方案

#1

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

不,Oracle数据库12c第2版(12.1.0.2)中引入了JSON支持

Regards

#2

If you install the latest APEX 5.0 which was released on April 15. You get access to a great API to work with JSON

如果您安装了4月15日发布的最新APEX 5.0。您可以访问一个很棒的API来使用JSON

I'm using it on 11.2 and have been able to crunch every single json, from simple to very complex objects with multiple arrays and 4/5 levels. APEX_JSON

我在11.2上使用它并且能够处理每个json,从具有多个阵列和4/5级别的简单到非常复杂的对象。 APEX_JSON

If you do not want to use APEX. Simply install the runtime environment to get access to the API.

如果您不想使用APEX。只需安装运行时环境即可访问API。

#1