title: DBMS_XMLGEN package limitations?
body: <p>I need to get a XML from the returning of a complex query. My previous examples in similar situations, I've used the DBMS_XMLGEN package context tyo generate the XML.</p>
  
  <p>But in this example, I have a problem:</p>
  
  <pre><code>    ...
      begin
      l_ctx :=
               DBMS_XMLGEN.newcontext (
                  'SELECT SIRENREC AS receiptNumber,
  ICPSCDDE AS companyCode,
               SISENPOL
                  AS policyNumber,
               SIREISIN AS claimNumber_aux,
               SUBSTR (SIREISIN, 3, LENGTH (SIREISIN)) AS claimNumber,
        sirevlre - sirevirs + sireviva,
                  AS receiptAmount
          FROM MTICPS,
               MTSIRE,
               MTSISE,
               MTINPI,
               MTRLRS              
         WHERE     ICPSIDEN = ''N''
               AND ICPSRFPG = :refPag
               AND ICPSCDDE = SIRECDDE
               AND ICPSISIN = SIREISIN
               AND ICPSNREC = SIRENREC
               AND RLRSCDDE = SIRECDDE
               AND RLRSSISE = SIREISIN
               AND RLRSSIRE = SIRENREC
               AND RLRSISIN = INPIISIN
               AND RLRSRECI = INPINREC
               AND RLRSCDDE = INPICDDE
               AND SIRECDDE = SISECDDE
               AND SIREISIN = SISEISIN
               AND SIREVLRE &lt;&gt; 0
               and rownum &lt; 110
            ORDER BY SIRECDDE, SIREISIN, SIRENREC');
        DBMS_XMLGEN.setrowsettag (l_ctx, 'INT_DATA');
            DBMS_XMLGEN.setrowtag (l_ctx, 'Item');
  
            DBMS_XMLGEN.setbindvalue (l_ctx, 'refPag', 'BLABLA');
      lxmltype := DBMS_XMLGEN.getXmlType (l_ctx);
  
            DBMS_XMLGEN.closeContext (l_ctx);
  </code></pre>
  
  <p>My problem here, I think, is the size. For exemple, if I put a <code>and rownum &lt; 110</code> condition, I can get all the XML and completed for 110 records. But if I have more than 110 records, my l_ctx variable is simply empty and my XML is empty.</p>
  
  <p>We have some limitations here? I've looked up in Google and Oracle documentation but I was not able to find any reference.</p>
  
  <p>Any help?
  Thanks.
  Filipe</p>
  
  <p>Edit1: I've found that I have a numeric or value error when converting the XMLTYPE to CLOB. I think my XMLTYPE is not null. It is just a large variable and I can't convert it to CLOB using xmltype.getClobVal();</p>