glebovpavel / IR_to_MSExcel

Oracle Apex plugin for Interactive Grid or Interactive Report
http://glebovpavel.github.io/Description_IR_TO_XSLX/
Other
39 stars 14 forks source link

IR_TO_MSEXCEL.get_affected_region_id: No region found #102

Open satyajitsinha opened 2 years ago

satyajitsinha commented 2 years ago

Hi, I have downloaded version 3.27. Most of the screens is working fine but in one screen I am getting the following error:-

is_internal_error: true apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR ora_sqlcode: -20001 ora_sqlerrm: ORA-20001: Version:3.25 ORA-20001: IR_TO_MSEXCEL.get_affected_region_id: No region found! ORA-06512: at "INTTSTFAM.IR_TO_MSEXCEL", line 97 < raise_application_error(-20001,'IR_TO_MSEXCEL.get_affected_region_id: No region found!'); > ORA-06512: at "INTTSTFAM.IR_TO_MSEXCEL", line 372 < v_affected_region_id := get_affected_region_id( > ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2417 ORA-06512: at "INTTSTFAM.IR_TO_MSEXCEL", line 393 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210200", line 682 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2378 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC", line 340 component.type: APEX_APPLICATION_PAGE_DA_ACTS component.id: 74478729323821211 component.name: PLUGIN_AT.FRT.GPV_IR_TO_MSEXCEL error_backtrace: ORA-06512: at "INTTSTFAM.IR_TO_MSEXCEL", line 393 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210200", line 682 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2378 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2417 ORA-06512: at "INTTSTFAM.IR_TO_MSEXCEL", line 393 ORA-06512: at line 4 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210200", line 682 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2378 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC", line 340 ORA-06512: at "APEX_210200.WWV_FLOW_PLUGIN", line 1943 error_statement: begin declare

begin wwv_flow_plugin_api.g_dynamic_action_ajax_result := IR_TO_MSEXCEL.ajax (p_dynamic_action => wwv_flow_plugin_api.g_dynamic_action,p_plugin => wwv_flow_plugin_api.g_plugin );end; end;

Can you please help?

Thanks Satya