APEX

Hello,

This might be simple for a lot of people here but I can't get it going...

The problem is that, I have a tabular form with 1 text field and 1 date field. I am using a PL/SQL anonymous block transaction to insert/update a view based on the field values. Insert is fine but update on the date field is not working - but no errors. The date field is a date picker('DD-MON-YYYY') column. Kindly help check the problem. Thank you.

Below are some codes that might be helpful

-- update statement in the block
update  del_ignore_conchold_v
set     conc_prog_name = apex_application.g_f03(v_row)
       ,remove_entry_date = apex_application.g_f04(v_row) 
where   row_id = apex_application.g_f02(v_row);

-- update trigger on the view
CREATE OR REPLACE TRIGGER APPS_TEST.del_ignore_conchold_v_upd_tr
   instead of update
   ON APPS_TEST.DEL_IGNORE_CONCHOLD_V referencing new as new old as old
   for each row
begin
   update apps.del_ignore_conchold_tbl@PROD
      set conc_prog_name = :new.conc_prog_name,
          remove_entry_date = :new.remove_entry_date
    where conc_prog_name = :old.conc_prog_name
    and   remove_entry_date = :old.remove_entry_date;
end;

Thanks,
Rownald