XML file manipulation question
Kevin_KSep 27 2012 — edited Sep 27 2012I have to generate a big xml file from oracle relational tables, write the output to server and then load it back into a LOB field in the database.
1) I am on Oracle version 11.2.0.3
2) I am able to write the file to a server directory
Is it possible to zip the xml file using oracle preprocessor , read it and then load it back into the database on demand?
Thanks
Kev