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