OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » JSON Parsing (Linux, Oracle 11.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

JSON Parsing [message #659630]

Tue, 24 January 2017 23:33

gopieee16
Messages: 28
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