| How to convert JSON into XML in Oracle 10g [message #683052] |
Mon, 30 November 2020 04:23  |
 |
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  |
 |
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
John Watson wrote on Fri, 25 September 2020 10:37Quote: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:45ok I've thanked
John Watson wrote on Fri, 25 September 2020 10:47Come 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. 
[Updated on: Mon, 30 November 2020 05:46] Report message to a moderator |
|
|
|
] 
Search
Help
Members
Register
Login
Home
