title: Support for JSON in Oracle 11g
body: <p>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. </p>
  
  <p>My main concern is whether it is possible to handle JSON objects returned from RESTfull API calls (using <code>UTL_HTTP</code> package) in PL/SQL code.</p>
  
  <p>This is how I call RESTfull APIs:</p>
  
  <pre><code>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);
  </code></pre>
  
  <p>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.</p>
  
  <p>Any thoughts?</p>
  
  <p>Thank you.</p>