Skip to Main Content
  • Questions

  • Converting Json Data into Oracle 11g

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Vinayak.

Asked: May 30, 2016 - 7:19 am UTC

Last updated: May 01, 2020 - 7:46 am UTC

Version: Oracle 11g

Viewed 50K+ times! This question is

You Asked

Hi frindz,


How to convert json data to Oracle Data ? ?


I tried by using the following code, but it showing json does not support 11g.



CREATE TABLE j_purchaseorder
(id RAW (16) NOT NULL,
date_loaded TIMESTAMP WITH TIME ZONE,
po_document CLOB
CONSTRAINT ensure_json CHECK (po_document IS JSON));


Please reply.....

I am using Oracle 11g, please give m supporting solution

and Connor said...

On 11g, there are two great utilities for handling JSON

APEX_JSON

https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635

and an open source one, PL/JSON

https://sourceforge.net/p/pljson/wiki/Home/

Plenty of example of each in the documentation and on the web.

or just upgrade to 12c :-)

Hope this helps.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

nice community

Vinayak S, May 31, 2016 - 4:54 am UTC

Thanks Connor McDonald,

Is the APEX_JSON available in 11g?

Muni, May 24, 2019 - 4:52 pm UTC

Hi Tom,

Checked the apex version in our 11g db and it is 3.2.1.00.12. From internet i can see the apex_json is available from 5.0 onwards. Is the 5.0 version of apex supported in 11g?


SELECT VERSION_NO FROM APEX_RELEASE;

3.2.1.00.12


select * from v$version ;


Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production

Thanks for your help!
Connor McDonald
May 27, 2019 - 6:06 am UTC

See MOS Note:1344948.1: Application Express (APEX) Database and Web Server Certification Reference:

For APEX 4.0, the minimum database version is 10.2.0.3
For APEX 5.0, the minimum database version is 11.1.0.7
For APEX 5.1, the minimum database version is 11.2.0.4

Apex_json in 11g

Hugo, May 01, 2020 - 5:30 am UTC

It's possible to install the Apex_json package only?
(In 11.2.0.4)
Connor McDonald
May 01, 2020 - 7:46 am UTC

Even if possible, you would then be in a poor support position should anything go wrong.

Why not install APEX .. even if you never *use* it, you will have the various utilities (including APEX_JSON) there for you.

And you might even then one day decide to use APEX ... because its free and awesome
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here