Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert JSON into XML in Oracle 10g

User_RFKSXNov 30 2020

Hi,
I work on Oracle 10g where it's possible to use the built-in functions for handling XML documents but not JSON datatype bacause as far as I know that is only possible from Oracle 12c on.
Aside from installing the APEX_JSON package, has anyone here some plsql or other ways to convert JSON into XML and eventually XML into JSON? Because whenever I have to load an external JSON file into a CLOB column I'll have then to convert it into an XML for managing it by using the XML built-in function in Oracle 10g.

Thanks in advance!
Mark

Comments

PhHein

Hi,

this ? https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html

Regards

I dont see a msi version in the link. whats the process to get the msi file.

PhHein

Have a look here:

https://www.oracle.com/technetwork/java/javase/documentation/msiinstallerfaq-2967694.html 

 It is available to Java SE Subscription, and Java SE Desktop Subscription subscribers, and is a commercial feature entitlement for  legacy Java SE Advanced and Java SE Advanced Desktop customers.
1 - 3

Post Details

Added on Nov 30 2020
3 comments
4,954 views