JSON Support in Oracle11g

Question

0.00/5 (No votes)

See more:

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:

SQL

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.

Appreciate your ideas/ methods in this regard.

Thank you.

Posted 21-May-15 23:39pm

Chathur

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2015-05-22T01:11:00

Solution 1

Oracle or any other kind of database should be used to store data.

Your Rest layer should handle processing the json and use the database for storage and retrieval.

You should not mix the two concerns even if the technology allows it or you find a hack/workaround.

Posted 22-May-15 1:11am

Mehdi Gholam

Comments

Chathur 22-May-15 7:32am

@Mehdi Gholam, Exactly. But this is actually an Oracle Application Framwork and from there I'm calling few 3rd party REST APIs. Our business logic resides in Oralce APIs (PL/SQL). Thats why I need to do the manipulation in PL/SQL Procedures before storing in database.

Mehdi Gholam 22-May-15 8:03am

Google : plsql json

GuyThiebaut 14-Dec-17 8:56am

"Oracle or any other kind of database should be used to store data."
Why bother wasting a solution post with this completely unhelpful answer?

Anyone who has worked on legacy code/databases needs to work with what they find and I find myself in the situation where I need to parse a string saved in an Oracle database as a JSON string.