Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive Report Download XLS Not working

M.broOct 23 2018 — edited Nov 20 2018

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>

<script type="text/javascript" src="/i/libraries/jquery/2.1.3/jquery-2.1.3.min.js?v=5.0.4.00.12"></script>

<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

This post has been answered by Carsten Czarski-Oracle on Oct 24 2018

Added on Oct 23 2018

#apex-discussions, #download, #excel

10 comments

3,666 views