Forum Stats

  • 3,837,822 Users
  • 2,262,300 Discussions
  • 7,900,399 Comments

Discussions

Interactive Report Download XLS Not working

M.bro
M.bro Member Posts: 128 Blue Ribbon
edited Nov 20, 2018 11:29PM in APEX Discussions

Hi Team,

Database  12c

Oracle Application Express : 5.0.4.00.12

I developed interactive report using check box / Without check out box both the report i have CSV,HTML,Email,XLS,PDF,RTF report format need to download . All the report CSV and HTML Working fine. But XLS File showing different error for sample i showed below error message. it's simple 5 to 50 records i having. Query also executing fine.

<div class="a-Form-error">ORA-06502: PL/SQL: numeric or value error: character string buffer too small
</div>
    
   </div>
   <div class="t-Region-buttons t-Region-buttons--bottom">
    <div class="t-Region-buttons-left"></div>
    <div class="t-Region-buttons-right"></div>
   </div>
</div>
</div>
</div>
</div>
</div>
    </div>
    <div class="t-Dialog-footer">
     
    </div>
  </div>
</div><input type="hidden" name="p_md5_checksum" value=""  /><input type="hidden" name="p_page_checksum" value="OqteLp7Xf842g_iE3EnYchuEGZY" id="pPageChecksum" /></form>
<div id="apexDevToolbar" class="a-DevToolbar a-DevToolbar--bottom" style="display:none"><h1 class="u-VisuallyHidden">Developer Toolbar</h1><ul class="a-DevToolbar-list">
<li><button id="apexDevToolbarHome" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Application Express Home Page" aria-label="Home" data-link="f?p=4500:1000:3128541159263">
<span class="a-Icon icon-home" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Home</span>
</button></li>
<li><button id="apexDevToolbarApp" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Application 190" aria-label="Application 190" data-link="f?p=4000:1:3128541159263::NO:1,4150,RP:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:190,15,190,15,15">
<span class="a-Icon icon-edit-app" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Application 190</span>
</button></li>
<li><button id="apexDevToolbarPage" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Edit Page 15" aria-label="Edit Page 15" data-link="f?p=4000:4150:3128541159263::NO:1,4150:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:190,15,190,15,15">
<span class="a-Icon icon-edit-page-alt" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Edit Page 15</span>
</button></li>
<li><button id="apexDevToolbarSession" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Session" aria-label="Session" data-link="f?p=4000:34:3128541159263:PAGE:NO:34:F4000_P34_SESSION,F4000_P34_FLOW,F4000_P34_PAGE,FB_FLOW_ID:12259607550158,190,15,190">
<span class="a-Icon icon-page-session" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Session</span>
</button></li>
<li><button id="apexDevToolbarViewDebug" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="View Debug" aria-label="View Debug" data-link="f?p=4000:19:3128541159263:::RIR,19:IR_APPLICATION_ID,IR_PAGE_ID:190,15">
<span class="a-Icon icon-page-debug" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">View Debug</span>
</button></li>
<li><button id="apexDevToolbarDebug" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Debug" aria-label="Debug" data-link="javascript:apex.navigation.dialog.close(true,function(pDialog){ apex.navigation.dialog('f?p=190:15:12259607550158::YES:::\u0026p_dialog_cs=19cVNeTlFZYcA5JSePU-VDibceQ',{title:'',height:'700',width:'2000',maxWidth:'2000',modal:true,dialog:pDialog},'t-Dialog--standard',this); });">
<span class="a-Icon icon-debug" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Debug</span>
</button></li>
<li><button id="grid_debug_on" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Show Grid" aria-label="Show Grid">
<span class="a-Icon icon-grid-layout" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Show Grid</span>
</button></li>
<li><button id="grid_debug_off" type="button" class="a-Button a-Button--small a-Button--devToolbar is-active" title="Hide Grid" aria-label="Hide Grid">
<span class="a-Icon icon-grid-layout" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Hide Grid</span>
</button></li>
<li><button id="apexDevToolbarQuickEdit" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Quick Edit" aria-label="Quick Edit" data-link="f?p=4000:4500:3128541159263::NO:1,4150,4500:FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW,F4000_P4150_GOTO_PAGE,F4000_P1_PAGE:190,15,190,15,15">
<span class="a-Icon icon-quick-edit" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Quick Edit</span>
</button></li>
<li><button id="apexDevToolbarThemeRoller" type="button" class="a-Button a-Button--small a-Button--devToolbar" title="Theme Roller" aria-label="Theme Roller">
<span class="a-Icon icon-theme-roller" aria-hidden="true"></span>
<span class="a-DevToolbar-buttonLabel">Theme Roller</span>
</button></li>
<li><button id="apexDevToolbarOptions" type="button" class="a-Button a-Button--small a-Button--devToolbar js-menuButton" title="Developer Toolbar Options" aria-label="Developer Toolbar Options" data-menu="apexDevToolbarMenu">
<span class="a-Icon icon-gear" aria-hidden="true"></span>
</button></li>
</ul></div>
<script type="text/javascript">
var apex_img_dir = "/i/", htmldb_Img_Dir = apex_img_dir;
</script>
<!--[if lt IE 9]><script type="text/javascript" src="/i/libraries/jquery/1.11.2/jquery-1.11.2.min.js?v=5.0.4.00.12"></script><![endif]-->
<!--[if gte IE 9]><!--><script type="text/javascript" src="/i/libraries/jquery/2.1.3/jquery-2.1.3.min.js?v=5.0.4.00.12"></script><!--<![endif]-->
<script type="text/javascript" src="/i/libraries/apex/minified/desktop.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="wwv_flow.js_messages?p_app_id=190&p_lang=en&p_version=5.0.4.00.12-9659887003117&p_builder=Y"></script>
<style> html {visibility:hidden;} </style>
<script type="text/javascript">
apex.security.framebreaker("S");
</script>
<script type="text/javascript" src="/i/libraries/apex/minified/widget.regionDisplaySelector.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/libraries/apex/minified/widget.stickyWidget.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/libraries/apex/minified/widget.stickyTableHeader.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/libraries/apex/minified/tooltipManager.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/libraries/hammer/2.0.3/hammer.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/themes/theme_42/1.0/js/modernizr-custom.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/plugins/com.oracle.apex.carousel/1.0/com.oracle.apex.carousel.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript" src="/i/themes/theme_42/1.0/js/theme42.min.js?v=5.0.4.00.12"></script>
 
<script type="text/javascript" src="/i/apex_ui/js/minified/devToolbar.min.js?v=5.0.4.00.12"></script>
<script type="text/javascript">
apex.jQuery( document ).ready( function() {
(function(){apex.initDevToolbar([{"pageId":"15","typeId":"5110","id":"105506934585089379","domId":"inv_lines_rep"}],"FOCUS",{"autoHide":"Auto Hide","iconsOnly":"Show Icons Only","noBuilderMessage":"This application was not run from the Application Express Application Builder or the Builder window cannot be found. The Builder will now replace the application in this window.","display":"Display Position","displayTop":"Top","displayLeft":"Left","displayBottom":"Bottom","displayRight":"Right"},42);})();
apex.theme42.initializePage.modalDialog();
});</script>
</body>
</html>

Thanks & Regards,

M.Bro

Tagged:

Best Answer

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,345 Employee
    edited Oct 24, 2018 8:30AM Answer ✓

    Hi Manikandan,

    that's right. The column limit for CSV is different to the column limit for XLSX. And there is actually no workaround - APEX imposes a hard limit on about 25 to 27 columns for the XLSX download (the technical reason is that internal limits are exceeded for more columns).

    So your options would be to ...

    a) go with CSV downloads - and open these in Excel

    b) use an Alternative for XLSX output like APEX Office Print ...

    Best regards

    -Carsten

Answers