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