oracle选择器,oracle-apex – 带[行选择器]的APEX表格形式：如何在提交时设置选定行中的列值...

阅读我对汤姆答案的评论.流程示例代码：

declare

l_map apex_application_global.vc_map;

l_region_id number;

begin

if :APEX$ROW_SELECTOR = 'X' then

select t.region_id

into l_region_id

from APEX_040100.APEX_APPLICATION_PAGE_RPT t

where t.application_id = :APP_ID

and t.page_id = :APP_PAGE_ID

and t.source_type = 'Tabular Form';

l_map := apex_040100.wwv_flow_tabular_form.get_row_values(

p_tabular_form_region_id => l_region_id,

p_row_num => :APEX$ROW_NUM

);

update my_table

set status = 'Cancelled'

where id = l_map('ID');

end if;

end;