Hi All
We are using Skillbuilders Super popup LOV for our apex 5.0 applications. We noticed a behaviour that when we submit any invalid value in the super popup LOV item and submit it for processing, then we are getting error -
Error in PLSQL code raised during plug-in processing.
ORA-06503: PL/SQL: Function returned without value ORA-06510: PL/SQL: unhandled user-defined exception
Did anybody else faced the same issue too? Any solution for this?
Here's the complete stack trace of the error -
ORA-06503: PL/SQL: Function returned without value ORA-06510: PL/SQL: unhandled user-defined exception
Technical Info (only visible for developers)
- is_internal_error: true
- apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
- ora_sqlcode: -6503
- ora_sqlerrm: ORA-06503: PL/SQL: Function returned without value ORA-06510: PL/SQL: unhandled user-defined exception
- component.type: APEX_APPLICATION_PAGE_ITEMS
- component.id: 105882580043002057
- component.name: P54_HOLIDAY_CODE
- error_backtrace:
ORA-06512: at line 266 ORA-06512: at line 591 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1033 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1047 ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_050000.WWV_FLOW_PLUGIN", line 1144
- error_statement:
begin declare FUNCTION apex_super_lov_render ( p_item IN APEX_PLUGIN.T_PAGE_ITEM, p_plugin IN APEX_PLUGIN.T_PLUGIN, p_value IN VARCHAR2, p_is_readonly IN BOOLEAN, p_is_printer_friendly IN BOOLEAN ) RETURN APEX_PLUGIN.T_PAGE_ITEM_RENDER_RESULT IS l_retval APEX_PLUGIN.T_PAGE_ITEM_RENDER_RESULT; lc_not_enterable CONSTANT VARCHAR2(30) := 'NOT_ENTERABLE'; lc_enterable_unrestricted CONSTANT VARCHAR2(30) := 'ENTERABLE_UNRESTRICTED'; lc_enterable_restricted CONSTANT VARCHAR2(30) := 'ENTERABLE_RESTRICTED'; l_name VARCHAR2(30); l_dialog_title VARCHAR2(32767) := NVL(p_item.attribute_02, p_item.plain_label); l_dis_ret_cols VARCHAR2(10) := NVL(p_item.attribute_03, '2,1'); l_searchable_cols VARCHAR2(32767) := p_item.attribute_04; l_hidden_cols VARCHAR2(32767) := p_item.attribute_05; l_map_from_cols VARCHAR2(32767) := p_item.attribute_06; l_map_to_items VARCHAR2(32767) := p_item.attribute_07; l_enterable VARCHAR2(30) := NVL(p_item.attribute_08, lc_not_enterable); l_max_rows_per_page PLS_INTEGER := NVL(p_item.attribute_09, 15); l_search_type VARCHAR2(32767) := NVL(p_plugin.attribute_01, apex_plugin_util.c_search_contains_ignore); l_loading_image_type VARCHAR2(30) := NVL(p_plugin.attribute_03, 'DEFAULT'); l_loading_image_def VARCHAR2(30) := NVL(p_plugin.attribute_04, 'bar'); l_loading_image_cust VARCHAR2(32767) := NVL(p_plugin.attribute_05, apex_application.g_image_prefix || 'processing3.gif'); l_effects_speed NUMBER := NVL(p_plugin.attribute_06, 400); l_clear_protection VARCHAR2(1) := NVL(p_plugin.attribute_07, 'Y'); l_no_data_found_msg VARCHAR2(32767) := NVL(p_plugin.attribute_08, 'Your search returned no results.'); l_return_col_num PLS_INTEGER; l_display_col_num PLS_INTEGER; l_loading_image_src VARCHAR2(32767); l_display_value VARCHAR2(32767); l_onload_code VARCHAR2(32767); l_sql_handler APEX_PLUGIN_UTIL.T_SQL_HANDLER; l_display_values WWV_FLOW_GLOBAL.VC_ARR2; l_search_values WWV_FLOW_GLOBAL.VC_ARR2; l_js_headers_array VARCHAR2(32767); l_crlf CHAR(2) := CHR(13)||CHR(10); BEGIN IF apex_application.g_debug THEN apex_plugin_util.debug_page_item ( p_plugin => p_plugin, p_page_item => p_item, p_value => p_value, p_is_readonly => p_is_readonly, p_is_printer_friendly => p_is_printer_friendly ); END IF; IF l_loading_image_type = 'DEFAULT' THEN l_loading_image_src := p_plugin.file_prefix || l_loading_image_def || '.gif'; ELSE l_loading_image_src := REPLACE(l_loading_image_cust, '/i/', apex_application.g_image_prefix); l_loading_image_src := REPLACE(l_loading_image_src, '#PLUGIN_PREFIX#', p_plugin.file_prefix); END IF; l_display_col_num := SUBSTR(l_dis_ret_cols, 1, INSTR(l_dis_ret_cols, ',') - 1); IF l_searchable_cols IS NOT NULL AND INSTR(',' || l_searchable_cols || ',', ',' || l_display_col_num || ',') = 0 THEN --User forgot to add display column as a searchable column, let's do it for them l_searchable_cols := l_display_col_num || ',' || l_searchable_cols; END IF; IF l_hidden_cols IS NOT NULL THEN l_hidden_cols := ',' || l_hidden_cols || ','; IF INSTR(l_hidden_cols, ',' || l_display_col_num || ',') > 0 THEN --User marked display column as hidden, let's remove it for them l_hidden_cols := REPLACE(l_hidden_cols, ',' || l_display_col_num || ',', ''); END IF; l_hidden_cols := TRIM(BOTH ',' FROM l_hidden_cols); END IF; l_return_col_num := SUBSTR(l