Hello
I have an Interactive GRID and would like to insert/update by PL/SQL on Processing (Interactive Grid - Automatic Row Processing (DML)). Therefore I have taken the code template in the Help area and adjusted for my table:
begin
case :APEX$ROW_STATUS
when 'C' then
insert into T_IB_SD_AIC_AUM_EXCLUSIONS_T ( cont_type_gk, validfrom, validto, bu_gk_list )
values ( :CONT_TYPE_GK, :VALIDFROM, :VALIDTO, :BU_GK_LIST )
returning rowid into :ROWID;
when 'U' then
update T_IB_SD_AIC_AUM_EXCLUSIONS_T
set cont_type_gk = :CONT_TYPE_GK,
validfrom = :VALIDFROM,
validto = :VALIDTO,
bu_gk_list = REPLACE(:BU_GK_LIST, ':', ',')
where rowid = :ROWID;
when 'D' then
delete T_IB_SD_AIC_AUM_EXCLUSIONS_T
where rowid = :ROWID;
end case;
end;
-> The column ROWID is present and defined as PK
- Update will be ignored, no error message but the original record appears after refreshing the region
- Insert statement returns an error message: Error: ERR-1002 Unable to find item ID for item "ROWID"
I'm a bit confused it says "item" because it's a column. I'm aware Apex is pretty stupid about hidden fields and made the ROWID column visible in the interactive Grid but still the same error message.
Anyone has an idea what the problem is and how to fix it?
-> Oracle Apex 19.2