3 Replies Latest reply on Mar 15, 2012 2:48 PM by paulj

    APEX & BI Publisher - report column amount limit?

      Hi all,

      I try to extend reports in an apex application by exports to output formats
      provided by BI Publisher.

      All reports work fine except one report that contains 39 columns.
      So I did several tests and found out that apex won't send report xml data
      to BI Publisher server if the report contains more than 29 columns that
      are marked to be included in export.

      Everytime I call that report apex returns an "empty" http response with a header like this:

      HTTP/1.1 200 OK
      Date: Tue, 02 Oct 2007 09:33:00 GMT
      Server: Server
      Content-Disposition: attachment; filename=test.xls
      <pre>report error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small</pre>
      Content-Type: application/excel
      Content-Length: 0
      Keep-Alive: timeout=15, max=100
      Connection: Keep-Alive

      The error occurs independent on selected output format.

      I am using apex version (3.0.1 patch applied to 3.0 installation),
      Oracle DB is + BI Publisher

      Is this a known limitation or a bug?

      Any hints are appreciated. Thanks in advance.