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!

Error running any application from Apex on my OCI tenant

myluismFeb 3 2022

Hi all.
I don't know if this post correspond here. This is my form Apex Instance and is happening on all my applications in a workspace.
I can login to Apex as Developer, but as can't run any of my apps. After login this error is raised:
Error in PLSQL code raised during plug-in processing.
Technical Info (only visible for developers)
is_internal_error: true
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: line 39, column 13: PL/SQL: ORA-00980: synonym translation is no longer valid ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387 ORA-06550: line 18, column 9: PL/SQL: SQL Statement ignored ORA-06550: line 17, column 12: PLS-00341: declaration of cursor 'SQL_CSR' is incomplete or malformed ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 301 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 340
component.type: APEX_APPLICATION_PAGE_REGIONS
component.id: 1339856828417004916
component.name: SQL Source
error_backtrace:

ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 301
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 340
ORA-06512: at "APEX_210100.WWV_FLOW_PLUGIN", line 1649

error_statement:

begin declare
function render (
        p_region              in apex_plugin.t_region,
        p_plugin              in apex_plugin.t_plugin,
        p_is_printer_friendly in boolean )
    return apex_plugin.t_region_render_result
is
    -- It's better to have named variables instead of using the generic ones,
    -- makes the code more readable. We are using the same defaults for the
    -- required attributes as in the plug-in attribute configuration, because
    -- they can still be null. Keep them in sync!
    c_region_static_id    constant varchar2(255) := p_region.attribute_01;
    c_highlight_page_item constant varchar2(255) := p_region.attribute_02;

    l_highlight_term varchar2(4000) := '';

    cursor sql_csr( d_region_static_id in varchar2 ) is
        select source_type, 10 seq, null series_name, region_source source
        from apex_application_page_regions
        where application_id = :APP_ID
            and page_id = :APP_PAGE_ID
            and static_id = d_region_static_id
            and ( source_type_code like 'PLUGIN%'
                or source_type_code like 'STATIC_TEXT%'
                or source_type in (
                    'Calendar',
                    'Easy Calendar',
                    'Interactive Report',
                    'Interactive Grid',
                    'List View',
                    'Report',
                    'PL/SQL',
                    'Tabular Form'
                )
            )
        union all
        select reg.source_type, fs.series_seq, fs.series_name, fs.series_query source
        from apex_application_page_regions reg,
            apex_application_page_flash5_s fs
        where reg.application_id = :APP_ID
            and reg.page_id = :APP_PAGE_ID
            and reg.static_id = d_region_static_id
            and fs.application_id = reg.application_id
            and fs.page_id = reg.page_id
            and fs.region_id = reg.region_id
            and reg.source_type in (
                'Flash Chart',
                'Map'
            )
        union all
        select reg.source_type, 10 seq, null series_name, to_clob(tr.tree_query) source
        from apex_application_page_regions reg,
            apex_application_page_trees tr
        where reg.application_id = :APP_ID
            and reg.page_id = :APP_PAGE_ID
            and reg.static_id = d_region_static_id
            and tr.application_id = reg.application_id
            and tr.page_id = reg.page_id
            and tr.region_id = reg.region_id
            and reg.source_type in ('JavaScript Tree')
        union all
        select reg.source_type, 10 seq, null series_name, to_clob(list_query) source
        from apex_application_page_regions reg,
            apex_application_lists li
        where reg.application_id = :APP_ID
            and reg.page_id = :APP_PAGE_ID
            and reg.static_id = d_region_static_id
            and li.application_id = reg.application_id
            and li.list_id = reg.list_id
            and reg.source_type in ( 'List' )
        order by 1, 2;
    sql_rec sql_csr%ROWTYPE;
begin
    if c_highlight_page_item is not null then
        l_highlight_term := apex_escape.html(trim(lower(v(c_highlight_page_item))));
    end if;

    for sql_rec in sql_csr( c_region_static_id ) loop
        if sql_rec.series_name is not null then
            sys.htp.p('<p><strong>'||apex_escape.html(sql_rec.series_name)||':</strong></p>');
        end if;
        sys.htp.p('<pre>');
        if l_highlight_term is not null then
            sys.htp.p(replace(apex_escape.html(sql_rec.source),
                l_highlight_term,'<span class="highlight">'||l_highlight_term||'</span>'));
        else
            sys.htp.p(apex_escape.html(sql_rec.source));
        end if;
        sys.htp.p('</pre>');
    end loop;

    return null;
end render;
begin
wwv_flow_plugin_api.g_region_render_result := render (p_region => wwv_flow_plugin_api.g_region,p_plugin => wwv_flow_pl
Comments
Post Details
Added on Feb 3 2022
1 comment
340 views