tag:blogger.com,1999:blog-7650323825349493997.post6888596004767209284..comments2023-09-10T01:00:24.167-07:00Comments on Expert Oracle: Load XML into DatabaseJignesh Kariyahttp://www.blogger.com/profile/13788638237047053842noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7650323825349493997.post-44620233121095985682008-08-19T10:07:00.000-07:002008-08-19T10:07:00.000-07:00Hi Jignesh I found your code for creating a proced...Hi Jignesh <BR/><BR/>I found your code for creating a procedure for loading xml into a databse very useful but, I now need to take that CLOB document I have created and do a reverse so to speak. I need to write a procedure that takes my CLOB document (let's keep it as "xml_clob"...which is now a table in my oracle application) and write it to a UTL_FILE creating several xml files because i would like to have each xml file contain no more than 1000 rows. I have no idea how to do this and could use your expertise on the subject. I have already created a directory that I would like to write the XML files to. The sample directory I have created is called (DIR_PATH) and the path we can call (\app\cov\exchange\).<BR/><BR/>Thanks in advance!<BR/>Chris JChris Jhttps://www.blogger.com/profile/13251788059219554112noreply@blogger.com