I have something similar to a master detail report. The upper section is a single record and lower section is multiple child records. In the lower section report, I want to add link (Remove) . When user the click the link, it should run a pl/sql and remove that particular child record. Fox example I have department at the top and multiple employees report at the lower section. With the employee records, I have a link Remove for each record. When User click remove, a PL/SQL process must run and update that particular employee records DEPT_ID to Null.( basically removing that employee from the Dept). How can I achieve with the link
Platform : apex.oracle.com Version 5
Thanks
George