I'm getting weird behavior in a form using Automatic Row Processing. I've created scores of these over the years and I've never seen this happen. This form/page worked the last time I used it (several weeks ago). However, today when I pull up a row in the form, update a value, and click 'Apply Changes' -- Apex returns an ORA-1403. Clicking on the information tab for the error I get the following result for the operation being performed:
begin begin select "IMPACT_CAT_ID","TITLE","DESCRIPTION","ORDER_ID","ACTIVE"
into wwv_flow.g_column_values(1),wwv_flow.g_column_values(2),wwv_flow.g_column_values(3),wwv_flow.g_column_values(4),wwv_flow.g_column_values(5)
from "IMPACT_CATEGORIES" where "IMPACT_CAT_ID" = :p_rowid for update ; end;
end;
In my automated row processing procedure: IMPACT_CATEGORIES is the table, IMPACT_CAT_ID is the primary key, and P61_IMPACT_CAT_ID is the primary key item. However, Apex seems to be trying to compare my primary key column of the table to the rowid of the table (at least it would appear to me that's what p_rowid is).
I tried re-updating the ARP process, and creating a *new* ARP process. Neither made any difference. Anyone have any ideas on what's causing this?
I'm using Apex 18.2 on Oracle 11.2.