Plugin not working in Apex version 22.2

[kimoturbo]

Hello,

The plugin was working fine for Apex 21.2. However, when I upgraded to Apex 22.2, the plugin stopped working. Will the plugin be updated to support Apex 22.2? I hope yes. Thank you.

[KamilKosiorek]

Hello, we are going to release a new version in January. See you soon.

[kimoturbo]

Hello,

May I ask Mid of January or End of January?

Happy Holidays!

[KamilKosiorek]

Hello, I can't promise anything, but I'd rather expect mid of January. Happy Holidays!

[KamilKosiorek]

Hello, @kimoturbo Can you show what exactly is your problem?

[kimoturbo]

Hello, @KamilKosiorek The plugin was working very well when I was using Oracle Apex 21.2.8. When I upgrade to Apex 22.2, the Plugin stopped working and always gives me an error message (Below). I think it is a compatibility error.

"Error in PLSQL code raised during plug-in processing. Contact your application administrator.

Technical Info (only available for developers) is_internal_error: true apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR ora_sqlcode: -6550 ora_sqlerrm: ORA-06550: line 4, column 29: PLS-00225: subprogram or cursor 'APEX' reference is out of scope ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 758 ORA-06550: line 4, column 1: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_SYS_SQL", line 1503 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 746 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1995 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2571 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 399 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 553 component.type: APEX_APPLICATION_PAGE_ITEMS component.id: 14605152699901401 component.name: P36_CUSTOMERS error_backtrace: ORA-06512: at "SYS.DBMS_SYS_SQL", line 1503 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 746 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 126 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2654 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 758 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1503 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220200", line 746 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 1995 ORA-06512: at "APEX_220200.WWV_FLOW_DYNAMIC_EXEC", line 2571 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 97 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC_PLSQL", line 399 ORA-06512: at "APEX_220200.WWV_FLOW_CODE_EXEC", line 553 ORA-06512: at "APEX_220200.WWV_FLOW_PLUGIN", line 1905 error_statement: begin declare

begin APEX.APEX_ENHANCED_LOV_ITEM.meta_data (p_plugin => wwv_flow_plugin_api.g_plugin,p_item => wwv_flow_plugin_api.g_item,p_param => wwv_flow_plugin_api.g_item_meta_data_param,p_result => wwv_flow_plugin_api.g_item_meta_data_result );end; end;"

[KamilKosiorek]

Hello, the error is not directly related to our plugin. As far as I understand your workspace is called APEX. Perhaps in the new version of APEX this word has become restricted. Try to edit the plugin and in the callbacks remove the part, "#OWNER#." from the render function, meta data and AJAX. I hope it helps you.

[kimoturbo]

Hello @KamilKosiorek Thank you so very much. I didn't know that APEX is a restricted word. Good to know. It worked like a charm! Can't wait to see what the new release will look like.

[kimoturbo]

Hello @KamilKosiorek Any news about the release of the new version? Thank you.