Oracle APEX 24.1 | Oracle DB 19c
Hi, I have an app on a remote server that is using an APEX Collection for the data in an interactive grid. When I submit the page, I get this error message:
ORA-02070: database does not support in this context ORA-06512: at "APEX_240100.WWV_FLOW_PROCESS_NATIVE", line 55 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 155 ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2676 ORA-06512: at line 3 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_240100", line 812 ORA-06512: at "APEX_240100.WWV_FLOW_DYNAMIC_EXEC", line 2636 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 130 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC_PLSQL", line 468 ORA-06512: at "APEX_240100.WWV_FLOW_CODE_EXEC", line 614 ORA-06512: at "APEX_240100.WWV_FLOW_EXEC_LOCAL", line 3073 ORA-06512: at "APEX_240100.WWV_FLOW_EXEC", line 4331 ORA-06512: at "APEX_240100.WWV_FLOW_EXEC", line 4369 ORA-06512: at "APEX_240100.WWV_FLOW_PROCESS_NATIVE", line 34 ORA-06512: at "APEX_240100.WWV_FLOW_PROCESS_NATIVE", line 1835 ORA-06512: at "APEX_240100.WWV_FLOW_PLUGIN", line 4275
The error statement listed is code that I am running in one of the processes, specifically, it is the code that inserts the records from the APEX Collection into an actual table.
It looks like this:
begin
-- Insert records which are new in collection
insert into mytable (id, other_table_a_id, other_table_b_id, amt, quantity)
select to_number(c001), :P2_ID, to_number(c003)
, n001, n002
from apex_collections
where collection_name = 'IG_MYTABLE'
and to_number(c001) is null;
end;
I am not necessarily surprised this is happening, as I typically run into quite a few issues when trying to do things on a remote server. However, I would like to understand why this is happening, and, if possible, find a fix.
Any help or insight would be greatly appreciated. I have a workaround in mind in case the APEX Collection simply won't work in this context, but if there is anything I can do to get it to work, I would love to keep it. I've also googled around and am not finding much on this specific scenario.