XMLAGG problem
530807Aug 30 2006 — edited Aug 31 2006We have stored procedure which creates a long string of XML (which is stored as a clob in the database column)using the xmlAGG and XMLElement. The stored proc calls sub functions which all run fine when called individually however when called collectively from the stored proc the xml generated appears corrupted with a section missing and always gets corrupted at the same point i.e. a sub function pulls back a number of installment records - when we try to retrieve more than 4 records 1016 bytes the result gets corrupted. We are using oracle 10g with the latest patches 10.0.2.0.2 and running it on a linux - we also tried it from a windows platform but get the same problem. We know its not the code that is the problem because it works fine from a linux machine. Has anyone else experience similar problems or have any ideas on how to resolve?