Home » SQL & PL/SQL » SQL & PL/SQL » JSON Parsing (Linux, Oracle 11.2.0.3.0)
JSON Parsing [message #659630] Tue, 24 January 2017 23:33 Go to next message
gopieee16
Messages: 26
Registered: May 2011
Location: Chennai
Junior Member

Hello All,

we have a requirement where we need to read JSON from a table and insert into to another. JSON is stored in CLOB column.

our Oracle Version is 11.2.0.3.0, we know oracle 12c supports JSON but we are not in a plan to upgrade.

These are the installed components


select * from all_registry_banners;

BANNER
--------------------------------------------------------------------------------
Oracle Database Catalog Views Release 11.2.0.3.0 - 64bit Production
Oracle Database Packages and Types Release 11.2.0.3.0 - Development


We installed XML database component and Apex run time variables to parse the json and perform the required task, we were successfully achieve the task in our local environment. But while installing the same in production XML db is installed successfully but Apex installation fails with ORA - 00406 Compatible parameter needs to be 11.0.0.0.0 or greater.

Our JSON and parsing script is too long to paste here so i have attached.

Can you please suggest us either to solve with APEX installtion or any other alternate way to parse the json with out upgradig to 12c

Thanks
Re: JSON Parsing [message #659631 is a reply to message #659630] Tue, 24 January 2017 23:34 Go to previous messageGo to next message
gopieee16
Messages: 26
Registered: May 2011
Location: Chennai
Junior Member

My json file is attached now
  • Attachment: JSON.txt
    (Size: 50.90KB, Downloaded 56 times)
Re: JSON Parsing [message #659643 is a reply to message #659631] Wed, 25 January 2017 07:47 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2699
Registered: January 2010
Location: Connecticut, USA
Senior Member
Use PLJSON package (you can download it from https://github.com/pljson/pljson).

SY.
Re: JSON Parsing [message #659680 is a reply to message #659643] Fri, 27 January 2017 04:03 Go to previous messageGo to next message
gopieee16
Messages: 26
Registered: May 2011
Location: Chennai
Junior Member

Thanks SY,

can anyone provide document to develop script using PLJSON
Re: JSON Parsing [message #659681 is a reply to message #659680] Fri, 27 January 2017 04:31 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you have a look at "doc" and "examples" directories?

Previous Topic: Doubt in SYS_CONTEXT
Next Topic: cursor leak and open cursors
Goto Forum:
  


Current Time: Sun Jan 21 03:48:14 CST 2018

Total time taken to generate the page: 0.01081 seconds