Home » SQL & PL/SQL » SQL & PL/SQL » How to convert JSON into XML in Oracle 10g
How to convert JSON into XML in Oracle 10g [message #683052] Mon, 30 November 2020 04:23 Go to next message
Mark70
Messages: 18
Registered: June 2020
Junior Member
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
Re: How to convert JSON into XML in Oracle 10g [message #683053 is a reply to message #683052] Mon, 30 November 2020 05:45 Go to previous message
Michel Cadot
Messages: 67847
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
John Watson wrote on Fri, 25 September 2020 10:37
Quote:
Could you tell me how to do it?
Yes, I can. The first step is to say "thank you" to the people who helped you in your previous topics.

Mark70 wrote on Fri, 25 September 2020 10:45
ok I've thanked

John Watson wrote on Fri, 25 September 2020 10:47
Come on, man. I do not see any solutions posted, nothing that would help anyone else learn.

leech

Besides, it is a somewhat interesting issue, I hope you will post the code when you'll find it. Smile

[Updated on: Mon, 30 November 2020 05:46]

Report message to a moderator

Previous Topic: Creating Procedure (2 merged)
Next Topic: week start from saturday
Goto Forum:
  


Current Time: Wed May 12 04:21:09 CDT 2021