Apex compatibility version 21.2 error
Closed this issue · 1 comments
DavideBar commented
Hello,
I have an Apex application that had the compatibility version: 5.1/18.1/18.2. And it was working flawlessly.
I had to move to the newer version: 21.2 because of theme migration.
After that change everytime I try to open a page that had the plugin I get the following error:
Error in PLSQL code raised during plug-in processing.
Contact your application administrator. Details about this incident are available via debug id "1125048".
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
ora_sqlcode: -22303
ora_sqlerrm: ORA-22303: type "APEX_210100"."T_DYNAMIC_ACTION" not found ORA-06512: at "APEX_210200.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210200.WWV_FLOW_DYNAMIC_EXEC", line 2417 ORA-21700: object does not exist or is marked for delete ORA-06508: PL/SQL: could not find program unit being called: "SCHEMA.PRETIUS_APEX_NESTED_REPORTS" 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](http://component.id/): 93053638723163507
[component.name](http://component.name/): PLUGIN_PRETIUS_APEX_NESTED_REPORTS
error_backtrace:
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 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_render_result := SCHEMA.PRETIUS_APEX_NESTED_REPORTS.pretius_row_details (p_dynamic_action => wwv_flow_plugin_api.g_dynamic_action,p_plugin => wwv_flow_plugin_api.g_plugin );end;
end;
Can you please help me, find the issue?
DavideBar commented
Fixed by compiling the package PRETIUS_APEX_NESTED_REPORTS spec and body.