I have 2 tables:
select emp_id,emp_name from emp;
select emp_id,filename,mime_type,doc_size,charset,content from emp_pic; --content is blob column for image
Emp_pic stores image of employee.
I need to create a report with form using both these tables such that report is combined as one and form takes all data together and processes into individual tables.
So, the query for the report with form(IG) is:
select e.emp_id,e.emp_name,i.filename,i.content where e.emp_id=i.emp_id;
Now for dml processing i need help with writing process such that it updates both the tables.
For dml we would need it for apex_rowstatus=C,D and U, i.e. insert delete and update.
P.S. The creation of view and triggers approach has been rejected so i need help with process such that the job is done.