Writing an XML file larger thatn 32767 char/bytes?

 Hi,

 I have an issue trying to create an XML file that is large CLOB file. 

 It maybe that we have to change our process. 

 I have a proceudure that we run from concurent process in Oracle 11i Apps.  We are on 10g database.   The pl/sql  procedure runs a query to create an XML file.  After the query runs,  another procedure  is called to write the XML file to a linux directory.

  This process works just fine until we try to write a file larger than 32767 chars.   Here is the script we use to try to write the file.