I have this query
BEGIN
FOR v_LoopCounter IN 1..50 LOOP
INSERT INTO dept_staff (sequential_number,department_id,schedule_date,
position,payroll_id,start_time,end_time,total_hours,
start_hours,start_minutes,end_hours,end_minutes,site_code)
select :dtl.sequential_number,:dtl.department_id1,:dtl.schedule_date,
:dtl.position_cd,:dtl.payroll_id,:dtl.start_time1,:dtl.end_time2,:dtl.total_hours,
:dtl.start_hours,:dtl.start_minutes,:dtl.end_hours,:dtl.end_minutes,:dtl.site_code
from department d,emp_unexcld e,dept_staff ds
where d.department_id = e.department_id
and e.payroll_id = ds.payroll_id
and ds.payroll_id = :dtl.payroll_id--'ZZW0023516'
and ds.schedule_date = :hdr.sched_date--'02-sep-2011'
and ds.site_code = :dtl.site_code;--'N208';
END LOOP;
END;
:system.message_level := '10';
do_key('COMMIT_FORM');
:system.message_level := '0';
-----------------
All the data gets inserted, other than site code. I tried to hardcode the value also but does not get inserted. Any Idea why? Forms experts?
2. Create an on insert-trigger on the dtl block
message(:dtl_empname? || ':' || :dtl.site-code); -- or an alert : add something (for example) empname to recognize the record
insert_record;
Do you get all exepected messages ?